Multiple Categories

  • Thread starter Thread starter Keith Ward
  • Start date Start date
K

Keith Ward

Hi,

In our product database I want to be able to list products in multiple
categories. Is this only achievable with a separate category Filed for say 3
categories? What if I want 10, 10 category fields in table?

Also our program that uses the database lists products that we can discount
for certain groups, I want to be able to add products to multiple groups,
similar to multiple categories.

EG

Product 1 in all groups.
Product 2 in all groups except group 2
Product 3 in groups 4 & 5

Is this best achieved with a check boxes in the table? So 10 checkboxes for
10 groups?

Thanks

Keith
 
You could do that, but it isn't correct database design. What happens when
you want and 11th, 12, or 300th category? What you should do is create 3
tables:

tblProducts
ProductID
ProductName
....

tblCategories
CategoryID
CategoryName
....

tblProductcategories
ProductID
CategoryID

the Product/Category table is a many-to-many intersection table which can
display as many or as few categories as you like for each product.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Of course, why didn't I see that.

Sometimes you just cant see the Pink Elephant for looking!

Thanks for the help.

Keith
 
Back
Top