In which lesson do we learn how to line up customer id's to relate to other table without entering the ID for each record in the other tables?
I basically have a table of "customers/clients" I want to create a few other tables of "clinic admits" and another of "client referrals" and I want them to all relate to the Custmer/Client ID in table one. I would like to import that data, but do I need to enter the Customer ID/Foreign ID for each record in each table or is there an easier way?
Tahnks..
Reply from Alex Hedley:
Do you have any matching data in both the client table and the table you wish to join too?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 2.