Combo box - How to lookup data

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

Guest

I've been away from Access 6 years, and I cannot remember how to do this.
I've looked for info, so please, even though this is simple, don't get upset,
just help me!

I have two tables, Clients and Projects. Linked 1 to many on ID. I want to
design a data entry form, based on a query that joins the two tables. On
data entry, new record, I want to select the client name (from tblClients)
and have it fill in the ID field (on tblProjects).

Thank you.
 
Back
Top