Appending records related tables - XML

[Pampers]

Hi everyone,
Importing data/table through xml is really easy. But now I want to append data of two related tables, tblMedicine and tblMedicineDetail both with autonumber ID's (Long Integer, incremental), to another database with also tblMedicine and tblMedicineDetail. Of course, errors occur because of duplicate values of the ID's. I use Get External Data, XML, Append Data to Excisting Table(s).

Question: how to go about this problem. How do you append data of related tables when you have long integer incremental autonumbered ID's? Would you append both tables seperate, and then 'manually' higher the ID's of the related table?



Pampers
Keeping it simple can be complicated

 

[Remou]

Thinking out loud ... how about appending a calculated number?

[tt]INSERT INTO tblMedicine ( ID )
SELECT ([ID]*100)
FROM tblImport;[/tt]

 

[Pampers]

That might be an idea. Tnx Remou.

Pampers
Keeping it simple can be complicated