Bridge Tables w/composite primary keys

beckie1234

Struggling Student
Local time
Today, 13:18
Joined
Mar 10, 2007
Messages
94
I am creating a bridge table to get rid of redundant data. I am doing it by making a composite of the primary keys from the two tables I am bridging.
The error message when I get to a certain point is "You cannot add or change a record because a related record is required in table tblMachCent." Both the numbers I am using to create this composite key are in the tables necessary, so I am not sure why I am getting this problem. Any suggestions??
 

Users who are viewing this thread

Back
Top Bottom