Hi can anyone solve a problem for me.

I have created a form in FileMaker Pro 5.0. It runs over 10 layouts. At the end of each layout is a 'Submit' button which takes you to the next layout. Most of the fields are required to be filled in so under 'Options' for each field I have validated them 'Not empty' and to 'Display a custom message if validation fails'.

So what I want to happen is if you are on layout 1 and forgot to enter your telephone number in the required field when you click on the submit button a message comes up "Please supply telephone number". Simple yeah?

No!!! What comes up is a message saying '"Supplier" is defined to require a value, but is not available on this layout. Use another layout to assign a value to this field'. You click on OK it comes up with a similar message for the next field then the next and so on through all 40 different fields until right at the end my "Please supply telephone number" message comes up.

How do I validate fields so that only missed fields in the current layout are flashed up with a warning message.

Regards

Graham

I would forget about using the define fields validation method for this. Since you already have a "submit" button, attach a script to it that has the following:

if isempty(Tel#)

show message "Please enter the telephone#"

go to field Tel#

HaltScript

endif

if isempty(ZipCode)

show message "Please enter the ZipCode"

go to field ZipCode

HaltScript

endif...

and at the end of the script have

go to layout 2

-Raz