Populate with data from another table

[Emma Aumack]

I have a dilema. . .

I have a task tracking database that users enter data regarding a task they
are beginning and dependent on the type of task they are entering, they will
enter details of that task into separate tables. When they are done with
that task, they enter a "completed date" in the Job Master Form. This
completed date is required because it is used to calculate turnaround times.
For example, to begin a task the user will enter data into a Job Master form
(this gos to the primary table tbl_Master_Jobs). Then they select a job type
from a drop down list. So for example, the job type would be "Debit Memo"
and a Debit Memo form will pop up which enters data into tbl_debit_memo. On
the form, they enter details about working the Debit Memo like product codes,
debit amounts, etc. . . included in the Debit Memo Form are certain dates.
One of the dates is the "Date_to_CS". When this date is filled in the users
would like this same date to also populate the "Completed_Date" in
tbl_MasterJobs. They do not want to have to go back to the Job Master Form
to fill in the "Completed Date".

Is there a way to get the date from the Debit Memo form (tbl_Debit_Memo) to
automatically populate the Completed date in tbl_Master_Jobs when the record
is saved in tbl_debit_memo???

Thanks!

 

[Emma Aumack]

I think I've solved my problem. I used an update query that fires when the
Debit Memo form closes. The query criteria looks first for all
tbl_Master_Job entries with "Debit Memo" in the job type, then looks for all
entries where the "Completed Date" is empty. Then updates those records with
the "Date_to_CS" from the tbl_Debit_Memo. If someone has a better solution
please share it with me.

Thank you,