Originally Posted by
June7
Addresses is the 'master' (or lookup table) it has the PK that is saved as FK in CompanyAddresses (the 'child' or dependent table).
You have a number field in ChangeOrderValues defined as part of a compound primary key and it is linked to autonumber field in JobItemValues. Yet the autonumber field is not defined as a PK, two other fields are defined as compound primary key. If you want to save the autonumber into ChangeOrderValues, then it should be PK and the other two fields can be set as compound index to prevent duplicate pairs, but not as compound key.