Jump to next field if field content is "N". Which formula?

[filemuker]

I have 3 fields:

1. Option-field: Y/N

2. Field1:

3. Field2:

If option-field = "N" than write "no" to Field1 and jump to Field2 and wait for input.

Which formula could make this "jump" -)?

[David Jondreau]

Two different aspects of Filemaker will make this work.

The first is in Define Fields, you want to set Field 1 to have an Auto-Enter calculation = Case(Option-Field = N; "No"; Option-Field).

The second is setting Tab Order, which you do in Layout mode. You can specify that Option-field is 1, Field2 is 2 and Field 1 is blank, or 3.

[filemuker]

You can specify that Option-field is 1, Field2 is 2 and Field 1 is blank, or 3.

first part works fine -).

I know the tab-order in layout.

What I don't understand is "and Field 1 is blank, or 3.". I don't know where I can input this instruction or order.

What I need is a jump to Field-3 if Field-2 = no

Edited April 21, 2007 by Guest

[comment]

You can make the option field a button that triggers a script. The script toggles the option field, then goes to whichever field is appropriate.