loneranger27
Programmer
Hi,
I have a query that finds customer info from the customer table then exports that infor to an excel file then finds all of the different accounts that person has and makes another excel file and then finds all of the orders per account and makes a third excel file. All is fine to here.
I now need to be able to import these files into someone elses database. I can put the customer info in and when I do my query assigns a new cutomer id because I cant have any duplicates. This Customer id is the foreign field that links the accounts to the customer, now this field has changed and I am not sure how to make the change in the second table import to change the forein key to the new key and still keep everything in sync. Does any one have any ideas that might help. I would appreciate it greatly
thanks
I have a query that finds customer info from the customer table then exports that infor to an excel file then finds all of the different accounts that person has and makes another excel file and then finds all of the orders per account and makes a third excel file. All is fine to here.
I now need to be able to import these files into someone elses database. I can put the customer info in and when I do my query assigns a new cutomer id because I cant have any duplicates. This Customer id is the foreign field that links the accounts to the customer, now this field has changed and I am not sure how to make the change in the second table import to change the forein key to the new key and still keep everything in sync. Does any one have any ideas that might help. I would appreciate it greatly
thanks