In Access XP and higher, Access should automatically keep your relationships OK as long as you are certain to rename the fields in both tables to the same thing. MAKE SURE you BACKUP your database before trying it though. If you have GLOBAL relationships, Access might not let you change the fields until you remove the relationships, however.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.