Hi all,

Come across a situation I cannot figure how to work out. Im relatively
new to access but have looked around and tried everything to my
knowledge.

I've developed an application whereby users load up the database and
open a form, this form issues them with work to complete, the work is
completed and the next record is offered.

There is a 'pot' of work that is loaded into a linked table every day,
when new work is given to the agent the row is taken from the pot and
stored in a local table (row in the pot then deleted) where over 10
minutes is regularly updated with outcomes and then moved to the
completed table.

Im having problems making sure unique work is given to each agent if
they were to click for another account at the same time.

At the moment two seperate queries do the above
1) retrieves the top 1 record from the pot into local table
2) deletes the record downloaded from the pot

between 1 and 2 the work form is refreshed and query 2 uses the job_id
field in the form to delete the remote record based on this field in
the form.

Does anyone have any ideas how to stop two being issued at once because
this happened almost numerous times whilst testing today.

Cheers for any help/pointers
Steve