but now am asking if its posible to have something like:
Why? You seem to be confused here on what you're actually trying to do. It might be a good time to understand how a database holds information and how you manage that information.
You have a column called Accessories in a Table called [Unit Order] The column contains rows (each item takes up a row)
Are you wanting more columns in your table to hold other information pertaining to each entry?
If you open your database table and look at the data, it will appear much like a listbox with a header of the column name.
First loop grabs Basin Level Platform
INSERT STATEMENT adds a new row putting Basin Level Platform in the Accessories column
Secon loop grabs Electronic Water Level Control Package
INSERT Statement adds a new row putting Electronic Water Level Control Package in the Accessories column.
At this point you have a datatable that contains one column with 2 rows.
Since you are only adding information into the single field (Accessories) you only need a single value.
How about trying the EXACT code you've been supplied in place of what you have in your For...Next loop and see what that gets you.
This post has been edited by CharlieMay: 11 October 2012 - 07:15 AM