First Question:

I have an Access Database with products. They are shoes actually. Now there is a dropdown list that has to be filled with the shoe sizes available for each shoe. I don't know what the easiest way to do this is. I was thinking of having a field named "Sizes" in the database table. The field would contain all of the sizes that the shoe is available in, each size seperated by a comma or semi-colon.

So, for example, the "Sizes" field for a shoe would be "10,10.5,11,11.5,12,13,13.5". Then this information would be added to the listbox. What I don't understand is how to seperate the shoe sizes by commas and let the server know that the commas seperate the values. There must be some kind of function to do this.

Second Question:

What is the easiest way to find a record in a recordset? I have a value name "ItemNo" and all of the "ItemNo" are unique. Not one is the same. I was thinking of doing this in SQL:

Dim iNumber
Dim strSQL
iNumber = SH005
strSQL = "SELECT ItemNo FROM Shoes WHERE ItemNo = iNumber"

But the SQL statement doesn't work for some reason.

Thanks, your help would be greatly appreciated...

-Simon