I have a split database where I've been working on the front end mostly with some changes to the backend (some new tables, fields, relationships). I've been working with test data, though there are a few records in a few tables in the test BE that I'm going to want to retain,
In the meantime, data has been entered into a remote back end separate from my test version while I was working on the front end via the test BE.
Now that I have the front end the way I want it, I want to bring the data from the remote back end into my new backend (again, which is similar but with some changes). The remote BE is not very large. There are about 18 tables total, the largest of which has about 500 records.
I understand I can use an append query to do this. I'm unclear on how the data will re-relate when Foreign keys will not equal the same ID # once these are imported or added into a table?
If someone can clarify this for me or maybe point me in the proper direction, I'd greatly appreciate it.
Thanks
In the meantime, data has been entered into a remote back end separate from my test version while I was working on the front end via the test BE.
Now that I have the front end the way I want it, I want to bring the data from the remote back end into my new backend (again, which is similar but with some changes). The remote BE is not very large. There are about 18 tables total, the largest of which has about 500 records.
I understand I can use an append query to do this. I'm unclear on how the data will re-relate when Foreign keys will not equal the same ID # once these are imported or added into a table?
If someone can clarify this for me or maybe point me in the proper direction, I'd greatly appreciate it.
Thanks