Multiple Categories

[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

 

[Arvin Meyer]

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

 

[Keith Ward]

Of course, why didn't I see that.

Sometimes you just cant see the Pink Elephant for looking!

Thanks for the help.

Keith