I have defined required fields for a table in my FM database. I will have the required fields spread over 4 layouts.

The trouble comes in when I click a button to proceed to the next layout. I get a message that says ' is required to proceed.'

But, the field names are on the other layouts that I am trying to proceed to by clicking a button.

Thanks

you probably have a script step that says "Go To Field []" yet you have not defined which field it is you want the script to go to.

No, there are no script steps involved.

I defined each field under Define Database to be required. I only use 5 fields on one layout and 5 field on another layout.

The user goes to Layout 1 and fills in the first five required fields. They click a button that that says go to Layout 2. This is when I get the message that says 'Fields 6-10' are required.

How can i handle this problem, because I cannot proceed to Layout 2 due to the other required fields not existing on Layout 1.

The trouble comes in when I click a button to proceed to the next layout.

Please, can you write the script attached to that button ?

The script step is 'Goto Layout 2.'

Thanks

have defined required fields for a table in my FM database. I will have the required fields spread over 4 layouts.

The trouble comes in when I click a button to proceed to the next layout. I get a message that says ' is required to proceed.'

This is the problem with field validations.

You might remove the field validations, and instead use navigation scripts to proceed from layout to layout. The navigation scripts can do the validations:

If [ isempty( field1 ) ]

Show message [ "Field missing data"; Ok ]

Go to Field [ field1 ]

Else

If [ isempty( field2 ) ]

Show message [ "Field missing data"; Ok ]

Go to Field [ field2 ]

Else

If [ isempty( field3 ) ]

Show message [ "Field missing data"; Ok ]

Go to Field [ field3 ]

Else

If [ isempty( field4 ) ]

Show message [ "Field missing data"; Ok ]

Go to Field [ field4 ]

Else

If [ isempty( field5 ) ]

Show message [ "Field missing data"; Ok ]

Go to Field [ field5 ]

Else

Go to Layout [ Layout2 ]

End If

End If

End If

End If

End If

Yes, that was the problem !

Because those fields are all from the same record and the validation comes when you ask to FM to change layout.

A stripped version of Ender suggestion can be:

If [isEmpty(field1) or IsEmpty(field2) or IsEmpty(field3)or IsEmpty(field4) or IsEmpty(field5)]

Show message [ "you must complete the form !";Ok ]

Else

Go to Layout [ Layout2 ]

End if

Thanks - I am not familiar with Navigation scripts, but each of your suggestions sound like they could work...

I'll try it...

Thanks again for the input.