P
Paul Springfield
I have created a database that we are using to audit
information. Each day, I dump data from our enterprise
system into the database and have a team of 12 start
auditing. I turned on the default record locking
to "edited record" under options advanced. I also created
a action to update a field in the main audtit table
to "Locked" when the user selects the Audit form. The
action runs on the On Load property of the form. The form
is filtered to only pull records where Locked is NUll.
Despite these two steps, I am still having the multiple
users grab the same record for audit. One of the team
member gets the message that someone else has the record
and drops all changes. Is there something that I am
missing to prevent this?
I am also having record information jumble on rare
occasions? Not sure why.
information. Each day, I dump data from our enterprise
system into the database and have a team of 12 start
auditing. I turned on the default record locking
to "edited record" under options advanced. I also created
a action to update a field in the main audtit table
to "Locked" when the user selects the Audit form. The
action runs on the On Load property of the form. The form
is filtered to only pull records where Locked is NUll.
Despite these two steps, I am still having the multiple
users grab the same record for audit. One of the team
member gets the message that someone else has the record
and drops all changes. Is there something that I am
missing to prevent this?
I am also having record information jumble on rare
occasions? Not sure why.