Form Record Dependancy

[rebekahlynn6]

I am building a database for multiple users within a department to manage the
flow of tasks. I am setting up a form for the Analyst, Accountant, and
Manager. My main table is "Tasks". There are certain tasks (each an
individual record) that are dependant on each other. For example, one task
would be to Prepare the Upload (assigned to Analyst), and the next task would
be to Review the Upload (Assigned to Accountant). Once the Analyst has marked
the Prepare the Upload task complete, I would like the Review the Upload task
to appear on the Accountant's form. Any suggestions?

 

[DStegon via AccessMonster.com]

Set a form timer and have it requery the data at an acceptable time frame.
Set your dataset for the form to only show those records that have the
"prepare upload" as true.