I have an access database which keeps track of patients and referring physicians. There are 3 tables, and numerous other objects to manipulate them.  The primary key on the contacts table (referring Physicians) is an auto number that links to the patients table( patient demographic data) and the patient encounter table (each individual appointment) Several months ago,  I made some changes to the database to improve is functionality and renamed the file new office management.    Unbeknownst to me for some strange reason my secretary continued to use the old database for referring physicians adding new contacts and editing old while using the new one for everything else.  . This comes under the heading of not being able to win for loosing. The simple solution would be to delete the contacts table in the new database and then export the old table into the new database.    However when I try to delete the contacts table in the new database, access warns me about the relationships I might be destroying.  My question is, will it work if I simply duplicate the relationships as they currently look in the new database?

---

Reply from Richard Rost:

You can go into the GLOBAL RELATIONSHIPS, delete the relationships, import the new table (replace the old one if needed) and then re-create the relationships. This will not cause any loss of data. It will work provided that all of your IDs match up. You probably have a CASCADE DELETE in place that's causing the warning.