Hi all,

I need to set up a table that will allow me to enter products into
certain categories, and within those categories, further
subcategories. However, I don't want cateogories to be "duplicated" to
allow for subcategories. For example, I don't want:

Clocks & Watches>Mantle Clocks      -and-
Clocks & Watches>Pocket Watches

I don't know if I have explained myself very well, but I hope somebody
can make sense of what I am trying to say!

What would be the best approach for this? Should I create both a
"Categories" table and a "Subcategories" table? My only concern was
that doing this would involve creating a new tale each time a new
subcategory was established - not very practial! 







 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/ms_access/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to