Table data sorting

  • Thread starter Thread starter Shreekant Patel
  • Start date Start date
S

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
 
As suggested in Tek-Tips, you should create a junction table of Description
Groups.

tblDescriptionGroups
================
DescID
GroupTypeID
 
Back
Top