Table Design

[Shreekant Patel]

I am new to the advanced level of access. I would like some tips on
table designs.

I have 2 tables that I have added to an existing database. Table 1
contains all the description values in one the columns. Table 2
contains 5 entries which are the group or categories that the
descriptions belong to. For example:

tblDescriptions

Column Headers: -
DescID, Description

Fencing
Bridges
Lighting
Ventilators

tblGroup

Columns: -
GroupTypeID, GroupType

Grp A
Grp B
Grp C
Grp D
Grp E

The issue I have is, some of the description values appear in more than
1 group. E.g. fencing could appear in Grp A, Grp B and Grp C and not
in Grp D and E. I can't seem to get around a suitable design on how
to manage the data. Do I need to create another table or add an
existing column within one of the tables with some sort of relevant ID
code?

Any help would be great.

Thanks
Shreekant

 

[Guest]

tblDescriptions
DescID (PK)
Description

tblGroup
GroupTypeID (PK)
GroupType

tblGroupDescriptions
GroupDescriptionsID (PK)
DescID
GroupTypeID

Use tblGroupDescriptions as the "one" in one-to-many relationships with
tblGroup and tblDescriptions. Then any group can be combined with as many
descriptions as you need, and any description can be applied to as many
groups as you need.

 

[Duane Hookom]

This is the third place I have seen the same question posted by the same
person. These have all been posted within about an hour or so of each other.
In each case, the answers were very quick and consistent.

In the future, please be more patient. Give someone a chance to reply before
posting the same question over and over.