Combo box - How to lookup data

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.
 
G

Guest

I FOUND IT! Never mind, but thanks anyway. It's so frustrating to have
forgotten so much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top