Next Field

[jeffEngland]

I have a value list and when I select a specific value I would like it to go to a specific field. Im running a mac and FM 8 advanced,

If anyone has any input it would be great

[mdpres]

You can do it one of two ways, but first you will need to write a script. The script can be along the lines of, If a certain condition is met in your value list do whatever (go to layout or go to specific field etc.) This can be triggered by a button or a script trigger plugin.

[jeffEngland]

Well I did apply it to a button and it executes a script if it equals a certain value, however I just have so many different values, my script would be ridiculously long, in a perfect world I would like to allow a variable inside the go to field script soo I would be able to go to that field when a certain value is chosen.

As of right now looks like that plug in may be the only option :

[mdpres]

There are ways of scripting variables.

How many values are you talking about?

[Fitch]

You could script it something like this:

Loop

. Go to next field

. Exit Loop If(Get ( ActiveFieldName ) = value)

End Loop

[jeffEngland]

The following is the code I have used it works, but it may not be the correct way to script Ive only stated using filemaker for about one week. The problem is I have to use this nested if statement about 40 times for all my variables and its too long.

If there is no way around it, does anyone know if this would take filemaker a long time to go through this script? and would it slow down my database?

Set Field[Lanes::Count; Lanes::Count=0]

If[Lanes::StartTimeConverted=32]

Go to Field [Lanes::R8:00; $$RegularLanes]

If[Lanes::Duration≥2]

Loop

Exit Loop if [Lanes::Count=Lanes::TimeMinutes]

Go to Next Field

Inserted Calculated Result[select;$$RegularLanes]

Set Field[Lanes::Count;Lanes::Count+1]

End Loop

End if

end if