AutoLookup query to update source table

[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

 

[[MVP] S. Clark]

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-