For some reason, duplicate tables were created in the Relationships window on 2 tables that have a relationship between them. 
tblCampus tblSchool
cam_id (PK) sch_id (PK)
cam_name sch_name
cam_id (FK)
I used the Lookup Wizard to create a combo box to pull info. from cam_name in the tblCampus to the field cam_id in tblSchool. The info. is pulled nicely, but then when I look in the Relationships window, duplicate tables appeared ( School_1, School_2 and Campus_1) and won't go away even after I delete them! They just come on back when I reopen the Relationships window.Argh!
All this because I was trying to get around another problem I was getting: I wrote an SQL statement to pull the info from tblCampus.cam_name (to cam_id in School) but could not select any of its values in the School form. Error message: You cannot add or change a record because a related record is required in table 'Campus'
tblCampus tblSchool
cam_id (PK) sch_id (PK)
cam_name sch_name
cam_id (FK)
I used the Lookup Wizard to create a combo box to pull info. from cam_name in the tblCampus to the field cam_id in tblSchool. The info. is pulled nicely, but then when I look in the Relationships window, duplicate tables appeared ( School_1, School_2 and Campus_1) and won't go away even after I delete them! They just come on back when I reopen the Relationships window.Argh!
All this because I was trying to get around another problem I was getting: I wrote an SQL statement to pull the info from tblCampus.cam_name (to cam_id in School) but could not select any of its values in the School form. Error message: You cannot add or change a record because a related record is required in table 'Campus'
