I have a split database with a main table and 2 junction tables that should be related. I was having trouble with blanks in my table so I decided to make a new backend and remove the auto name correct and clean up a few things. The main table has over 30,000 records in it so far, and I was thinking that I would just switch the team to the new back end, and then copy over the records that were entered in the old one while I was working on the new back end - about 300 hundred records. I didn't even think of the fact that when I copied the records from the main table over to the new backend, the autonumber (RecordID) changed, and no longer matches the RecordID on the 2 junction tables. I exported both to excel to compared the new ID to the old one, found that number on the junction tables and updated it, and then copied that data back into the junction tables. I forgot to check my relationships to the tables and went to set them up afterwards, and it won't let me enforce referential integrity because it says there are unmatched records. It is turning into a giant cluster. How do I fix this?! I still have the original data, it just has different IDs now. Any ideas??