Posted by NC on 10/08/05 01:58

google@charliefortune.com wrote:
>
> Is it possible to fill a field with multiple values ? I am cataloguing
> products that can fall into multiple subcategories (all of which are
> referenced by an id key to another table containing the subcat titles,
> i.e. 0=vintage, 1=mens, 2=womens etc.)

Bad idea. You need three tables; items, subcategories, and links.
Then an item cam have multiple links pointing to multiple
subcategories.

> What I really want is an enum type field that I can fill with more than
> one value.

This is not the way databases work, unfortunately...

Cheers,
NC

[Back to original message]