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