Hi,

I have created a shopping cart using Ultra Cart. I have two fields in my recordset - Size and Colour. For each of these I need to generate a dynamic list/menu. This is normally okay, but i need it to come from one recordset in the Access database.

I need to spilt the content in the record to create a drop down selection. E.g. In the field 'Colour' I have placed in the record value : blue;red;green;black.
I need a drop down menu - blue, red, green, black.

I am sure this can be done but I am not sure how. I need to split the values up in the Access record by a symbol i think like ' ; ' - is this the way.

Thanks in advance

research this:

split it into an array using split() (.asp) or explode() (.php)