Go to record where g_selection equals Name

[awayand]

Hi guys,

this one seems simple but I can't figure it out.

I want the user to enter a value into a global Field. Say he enters "Fred". I want to create a script, that will change the layout and go into Browse mode as soon as the person entered "Fred" and hit a button. However, the script should automatically jump to the record that has the value "Fred" inside of its "Name" field.

Can you guys help me out?

I'd love to hear your ideas...

[danjacoby]

Create a calc field that returns a number based on the contents of the global field. Now create a script to "GoToLayout" and Specify: Layout Number From Field, using the calc field to specify the number.

Kludgy, but it works.

[Pupiweb]

Make a relationship between the global field and the name field

Attach to the button a script like

Go to related record (Upmentioned relationship)

Go to Layout (Detail layout)

[awayand]

How would I set up the calculation?