F
fieroguy
Hi,
I am making a database for work and it tracks how long an item takes to
process after the work has been completed. I have 2 tables, one that
lists the job (1), and one that tells when its been completed and gives
a summary of the work(2). Table 2 is not updated until the work has
been complete so there is no record of that job in it at all.
I need to find a way to update the one that lists the job (I have a
check box field) when the information is entered into the other one. Is
there a way to say:
IF table 2 has the information in it then place a checkmark in the
field in table 1?
Thanks,
John
I am making a database for work and it tracks how long an item takes to
process after the work has been completed. I have 2 tables, one that
lists the job (1), and one that tells when its been completed and gives
a summary of the work(2). Table 2 is not updated until the work has
been complete so there is no record of that job in it at all.
I need to find a way to update the one that lists the job (I have a
check box field) when the information is entered into the other one. Is
there a way to say:
IF table 2 has the information in it then place a checkmark in the
field in table 1?
Thanks,
John