Bridge Tables w/composite primary keys (1 Viewer)

beckie1234

Struggling Student
Local time
Yesterday, 21:04
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

Top Bottom