I am usinging Filemaker 3.0 with Windows98 operating system. I have a "customer" and a "sales order" database. I have created a script (actually two scripts) that go from the customer database to the sales order database. Basically, it is desigend so the sales clerk can find the customer information, then hit a button which opens a sales slip which has the customer information on the top of the order form.

I have two "must enter" fields (that allow the users to overide the must enter) in the sales order database. When the user hits the button to go from the customer database and create a new order form, instead of the order form appearing, it stays in the customer database and a pop up message appears that says the "salesperson" field must be enetered, and them a second pop up appears that says the "method of payment" field must be entered. These are the must enter fields in the sales order database, but the screen still shows the customer database. So, the program did seem to switch databases as I want them too, however the screen does not show the database the program switched too. I tried to refresh the screen in the script, and this does not seem to help. Any ideas why the sales order form is not on the screen, when the program must have switched databases, or else it would not be asking me for the must enter items?

The best solution is not to use the built in validation, but to script tests for completion of entry into the fields. This way you have full control over the navigation that happens as a result of empty fields. -bd