Two Yes/No fields

[Pestomania]

Hi! I am trying to figure out the best way to do this.

I have two access queries. Person 1 and Person 2. There is a checkbox for Person 1 to send to Person 2. When Person 2 is done, they would select a checkbox showing complete and it would go back to person 1. I am unsure of how to get the query or table to work like the following:

When Person 1 checks their box, it shows on Person 2 queue. When Person 2 checks their box, it shows on Person 1 queue.

I want the boxes to follow this syntax:
Both Box 1 and Box 2 are empty
When Box 1 is true, Box 2 is false
When Box 2 is true, Box 1 is false

How would I go about doing this?

Thank you

 

[mole999]

just a question. is that an infinite loop, or does 2 submitting back to 1 finish the task

 

[Pestomania]

just a question. is that an infinite loop, or does 2 submitting back to 1 finish the task

The idea is Box 1 submits the job to Person 2. Box 2 submits it back to Person 1.

 

[mole999]

so the task never concludes ?

 

[Pestomania]

so the task never concludes ?

There is a different box that is labeled "Complete" when that is selected, it won't be shown on any queue.

 

[mole999]

so i'm thinking of an update query that has two boxes, both blank to start with and then returning to max date/time until your complete box is updated, not sure how to code for that though