Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
Not shown are bunches of other tables with a foreign key of Customers.id.
Customers-Main.mdb id name date 1 Bob 1/1/2005 2 Jack 6/1/2005 3 Fred 1/1/2007 4 Jerry 12/31/2010
All is well. BUT, I'd like to also be able to do a restore as well, meaning in the above example if I restore all rows beginning 1/1/2015, the id=1 and 2 rows move back to the Main.mdb, and because of the foreign key rows I need to specifically insert the values 1 and 2 into the AutoNumber ID field.
Customers-Main.mdb Customers-Archive.mdb id name date id name date 1 Bob 1/1/2005 2 Jack 6/1/2005 3 Fred 1/1/2007 4 Jerry 12/31/2010
Join the community of 500,000 technology professionals and ask your questions.