I c.. I've just wrote the two for loops I'm trying..
what i mean is rows are added with the same idorder that is related to a master order table so there a relation ship to
orders
customer
products
this worked..
'testing start
sql = " SELECT orders_split.idorder, orders_split.inorout, orders_split.details, orders_split.sku, orders_split.qty, orders_split.idproduct, orders_split.price, orders_split.taxAmount, customers.idcustomer, customers.name, customers.phone, customers.email, customers.shippingaddress, customers.shippingcity, customers.shippingstate, customers.shippingcountry, customers.shippingzip, customers.customerType, customers.address, customers.zip, customers.state, customers.city, customers.country, orders.authorised, orders.total, products.Stock, orders.subtotal, orders.postage "
sql = sql & " FROM ((customers INNER JOIN orders_split ON customers.idcustomer = orders_split.idcustomer) INNER JOIN orders ON orders_split.idorder = orders.idOrder) INNER JOIN products ON orders_split.idproduct = products.idproduct "
sql = sql & " WHERE (((orders_split.idOrder)="&rsId("idorder"

&"

)"
set rs = connTemp.Execute(sql)
arr = rs.GetRows()
'ReDim Preserve OrderArray(50,rs.RecordCount())
%><table ID="Table1"><tr><%
for i=0 to UBound(arr)
'Response.Write "<BR> element 0"&arr(i,0)
%><td><%
for j=0 to UBound(arr)
Response.Write "<BR> element 1"&arr(i,j)
next
%></td><td><%
next
%></td></tr></table><%
'testing start