User Form setup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg H. - 26 Sep 2007 16:12 GMT

I’m not sure how this can be done but here is the situation. I have a table
of records that users will take that information and input it into another
program. When completed they will click the checkbox that will indicate its
done. Because I will have approx 3 people working in the database doing
this, I don’t want the same record to be worked on by more then one person.
What I need is a way for a user to be given a new record and when a second
person tries to pull up a record to work on, it will not pull back one that
is currently being worked. How can this be done? Thanks

PS if this did not make sense, let me know and ill try to explain again.

Reply to this Message

Pieter Wijnen - 26 Sep 2007 19:55 GMT

A rather simple & dirty way to do it is record the ID that each user is
working on in a table & lookup to see wether it is available for edit
this is offcourse susceptible to crashes, etc (the dirty part)

HTH

Pieter

> I'm not sure how this can be done but here is the situation. I have a
> table
[quoted text clipped - 10 lines]
>
> PS if this did not make sense, let me know and ill try to explain again.

Reply to this Message

Greg H. - 26 Sep 2007 20:44 GMT

How would i do that? Is there a way to flag a record before it is saved as
completed so that the next person who is working on the table at the same
time does not get thta same record?

> A rather simple & dirty way to do it is record the ID that each user is
> working on in a table & lookup to see wether it is available for edit
[quoted text clipped - 18 lines]
> >
> > PS if this did not make sense, let me know and ill try to explain again.

Reply to this Message