Hi All,

I've been googling this for a while, and still no luck in terms of what
i'm after.
I have a DB with each record identified by a unique ID called
JobNumber.

I am trying to create a script to ask the user to type a Job Number,
and on hitting OK, the user is taken to the specific job (and a
specific layout).
What I have done is create a global field: gDummyJobNumber, and I am
using this in the dialog box that shows up.
Using the goto record/request etc with the gDummyJobNumber as the field
is not working.

I have tried creating a self relationship with
gDummyJobNumber=JobNumber and then using the goto related record, still
no success.

Anyone has any ideas?
I'm using FMP7

Thanks.

You are definitely on the right track. Relate your global field to your
actual job number field, and be sure to use the "Go To Related Record"
script step, not the Go To Record/Request step.

In article <1162473876.826641.83550 (AT) h54g2000cwb (DOT) googlegroups.com>,
"Paul Bruneau" <paul (AT) ethicalpaul (DOT) com> wrote:

The other way is to not bother with a Relationship at all and just
script a Find.
eg.
Enter Find Mode []
Set Field [JobNumber, gDummyJobNumber]
Perform Find []
Go To Layout [whateverlayout]


Either way, you also need to include some error catching routines in
case the user enters a Job Number that doesn't have any records.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)