Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Newbie: Access table design question

2 views
Skip to first unread message

Bex

unread,
Mar 21, 2005, 10:27:07 AM3/21/05
to
Just in need of a bit of advice.

I'm currently building a database to store information about different
products. Currently about 350 products with 12 different product
ranges (i.E Publications, Clothing etc)

The decision I have to come to is I have about 6 fields which apply
only to certain product ranges I.E 6 out of the 12 and the problem i
have is that in some cases all 6 fields apply to a x number of product
ranges, sometimes 4 fields will apply to a smaller number of ranges
and in other cases only one field applies to one specific category.

What I'm trying to decide is would it be better to put all of the six
fields in one seperate table to then link to the main table of data or
seperate the fields out into seperate tables for the differnet product
categories they apply to. The later method would mean the same type of
field defined in numerous tables, the former would mean i would end up
with some empty fields.


Brain is going numb as it's been a long time since i did DB design so
any views/help would be appreciated.
Thanks

0 new messages