Re: I want to store multiple values in a single field
Posted by google on 10/09/05 17:38
Thank you both, I now have products, categories and subcategories
tables.
As I understand you, NC, there is a link table with an id corresponding
to the id's in the products table, and each entry has, say, 3 fields
with subcategory id's ? Then when I SELECT items subcategorised as
'vintage', I do a JOINed SELECT using 'links' and 'products' ?