Help me link these tables

[Craigbob]

Hi,

I have two tables I need to link in Access. Table 1 will be used as a look
up table and contains a 2 part primary key and a description.

The table 2 has multiple fields that can hold the each part of the primary
key of the look up table.

I.E. Table 2 has a structure like so:

SvcNotifNo (PK)
1stCodegrp
1stdmgCode
1stCauseCodeGrp
1stCauseCode
(up to 5 iterations of this format are possible)

I've thought about normalizing this, but there is no guarantee that there
will be data in any of the fields. A record can have 1stdmg codegroup and a
2nd causecode but not a 1st cause code.

I'm stumped on how to do this.

Any help appreciated.

Craig

 

[Duane Hookom]

I wouldn't go any further with this until the tables are normalized.