Import New Data, link to existing table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm new to Access, so if this question is overly simple (or vague), please
forgive me.

I created a table, call it 'Customers', and imported data to it.
I created an autonumber field as the key field.

I now want to create a second table, call it 'Sales' and link it to the
first based on the key field.
My problem is the data for the second table does not contain the key field.

So, how can I import it and link the two tables so that there is one
'Customer' (table 1) and many 'Sales' (table 2)

Thanks
 
Your question is neither overly simple or vague. it can be done, but if you
are new to Access, it may be a bit of a challange.
Import the sales table into a temporary table you will delete later
Create the structure for the permenant sales table including the Customer
Key field.
Create an Append query that will use the customer table and the sales table
as source data. Join the two tables on a field(s) that will match the sales
to the customers. For most of the fields you want to update, you will use
the field values from the temporary sales table. For the field you created
to join the two tables, use the Customer key field as the source data.

Hope this helps
 
Back
Top