G
Guest
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
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