Thanks Duane,
If you're still watching this thread I have one more question. I set up my
database as you suggested & have a subform showing completed tasks for the
ECR. The subform is locked & I have a button to bring up another form that
automatically enters the ECR number in the proper field & the user must enter
their name, task completed & date. when they close the form the subform at
the bottom of the main ECR form shows the list of completed tasks. However
one of the tasks is to actually enter the ECR itself. It seems to make more
sense visually to leave the "OriginatedBy" & "DateInitiated" fields in the
main table so the user can just tab through the fields & save the record for
action at a later date. If I do this & link the
EmployeeID to 2 tables, I get no records in my query. Can you give me some
advice on how to approach this?
Thanks for your help!

"Duane Hookom" wrote:

Yep. You should have a subform that allows any number of tasks with the
associated fields. This is very common.