Importing into a new table w/ appropriate linking key
I have a Customers table with a set of serial numbers (primary keys) attached to each entry. I have a second table called Orders that are linked to the customers through the primary key. It is a one to many relationship.
I want to import new orders into my Orders table. At the moment, the only way for me to import and link is to make a column in Excel and write the customer key the orders are going to be related to in every row. I need to do this each time I import.
Is there any way, using scripts, for example, to import my orders and have it auto relate (aka, auto populate the key) to the Customers table? I already know which Customer it needs to link to, I just need to do it manually....
I import lots and lots of data so I need it to be as seamless as possible.