AutoLookup query to update source table

  • Thread starter Thread starter Susanne
  • Start date Start date
S

Susanne

I am working on a training records database. I have
created a course lookup table - this has key;
coursetitle; clustertopic and category. In the training
events table I want to be able to select a course title
from the linked categories table and the other 2 fields
to be entered automatically.

I have created an autolookup query to automatically
insert the rest of the info (two fields) from the lookup
table - this works fine in the query but I can't work out
how to update the original main table with the 'foreign
fields' data. Can anyone help, please?

Thanks in advance
 
Why do you need all of this information entered into another table?
Typically, you only need to store the courseID.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top