I'm not sure if this is a common problem or not, I couldn't find anything else here - but it could keep from having to rewrite an area of my system.

Some background, I have an standard order/invoice database. When the order comes to the stage were it is to ship. The user is prompted sequentially if they want to make one of four different shipping forms (Customs, Cargo Manifest etc etc). The forms are in another database and are edited in 4 different layouts in that database. As well, the forms database is accessible all the time since each order can have more then one form of each kind.

When the user clicks a button to run a script to do all the shipping stuff in the orders database, as well as prompt the user if they want to make the respective form. If they do, I want to run a script in the forms database the makes the new record and takes them to layout needed to edit it. Once they have completed, there is a button to exit and print. Right now, it will just prompt the user four times right after another with swtiching the layout in the forms database in the background. I want to be able to stop the shipping script in the orders database while the users enters the info in the forms database, once done, keep running the shipping script, which will prompt the users for the next form.

I've tried Exit Script/Halt/Pause with no luck. Is there an easy way around this?

Could you be more specific.

When the user clicks a button to run a script to do all the shipping stuff in the orders database

What is exactly that script doing ?

as well as prompt the user if they want to make the respective form.

Is this a show message step (OK/NO) ?

Sorry, I just want to make sure about the steps of your script.

Probably the If() statement selecting the data entry layout is wrong

I tend to find easier to handle and troubleshoot separate scripts rather than a single big script

In your case I'd make

- a script selecting the data entry layout, that goes to the proper layout

- a second script in the data entry layout that continues the shipping procedure

This also has the advantage of letting you add validations along the road and to stop the procedure if validation fails

Alternatively consider to create some global fields, make the user fill them with shipping parameters, validate their content, and - only at this stage - create the new record in Shipping and fill it with global fields values

I'm having a smililar problem. I have a script that does a consistency check. If the data is inconsistent, the script sends the user to another layout where he/she enters the reason. In order to allow the user to enter their data, I have to pause the script.

In the new layout, there are a few things that the user has to do. I need to run a script to check for that, then resume the original script.

I can use a button action of "resume script" to do that but then I can't run the 2nd script.

Anyone have a clue?

I reread the answer to the original question and finally understood...I fixed the problem by calling a 2nd script and pausing inside that script instead of going to a 2nd layout.

Sorry for the waste of bandwidth.

Dave