AnsweredAssumed Answered

Importing into a new table w/ appropriate linking key

Question asked by LeahRiley on May 15, 2013
Latest reply on May 16, 2013 by philmodjunk

Title

Importing into a new table w/ appropriate linking key

Post

     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.

Outcomes