Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.