Multi-user environment and scripts that import

[blindbo]

Datafile A is used by many users. They create new records, do their data entry and then "submit" this record to Datafile B.

The script in Datafile A omits the record, shows omitted, then performs a script in Datafile B which imports records, creating a new record in Datafile B. That is fine and dandy, unless another user executes submit during the process. How do I lock out users until the first script completes?

Please go easy on me. I am learning this by the seat of my pants!

[DonH]

Let me try and understand what you are saying.

You have a database named "A" which is where the clients interact to create new records. When they click "submit" a script is run on a database named "B" that imports the new record and then deletes the record from "A".

Is that how it is supposed to work?

[blindbo]

Yes, Don, that is correct.

Any suggestions?