To cut a long story short, I need to pull orders from one copy of the Actinic database into another. So I hit the key problem - they are sequential numbers and each database will have duplicates.
The Order table has the key OrderSequenceNumber, which is then the foreign key in the OrderDetail table.
The OrderDetail table has its own key - OrderDetailId - another sequential number.
I can add temporary fields to the tables - and write a query to add new values which start at one more than the records in the second database. And then copy these values back into the key and foreign keys. Then I can merge the tables with append queries. Whew.
Any other problems I will need to deal with? And do I need to rescue any other tables to give my client their sales history?
Thanks.
The Order table has the key OrderSequenceNumber, which is then the foreign key in the OrderDetail table.
The OrderDetail table has its own key - OrderDetailId - another sequential number.
I can add temporary fields to the tables - and write a query to add new values which start at one more than the records in the second database. And then copy these values back into the key and foreign keys. Then I can merge the tables with append queries. Whew.
Any other problems I will need to deal with? And do I need to rescue any other tables to give my client their sales history?
Thanks.