|
|
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
Navigation:
[Reply to this message]
|