Table data sorting

[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

 

[Duane Hookom]

As suggested in Tek-Tips, you should create a junction table of Description
Groups.

tblDescriptionGroups
================
DescID
GroupTypeID

 

[Shreekant Patel]

Thanks for your help. Working on this method.

Shreekant Patel