Populating one field based on another

[thedanch]

Hello,



I've got three tables. One is Jobs, where Job_ID is the primary key. Each job has a client_id, which is another table.

In the third table, where timesheet data is entered, I've got both the Job_Id and the client_id.
Is there a way to make the client_id auto-populate based on the job_id in that table?

Hopefully that makes sense.

Thanks

[thedanch]

I'm thinking I need to be using Dlookup and some VBA... Does that sound about right?