Hi

Using FM 8.5 Advanced.

I have a layout which among other fields has a field where I enter a number.
This number is a reference number to a record contained within another
table. On the same layout is a button which calls a script. The idea of this
script is to find the record contained in the other table. Some of the data
within this table is recorded within variables, the script then returns to
the original table and places the data collected into some other fields of
the record in my first table. All well and good and it works well.

The only problem I have is if I enter an invalid reference number I get the
standard "No records match this set of find requests", which in turn takes
me to the layout of the table from which I was attempting to find a record.
What I want is to go back to my original layout and be able to re-enter the
reference number to find there. Is there a way to do this?


--
Jeff Wright

Before Perform Find step:

Set Error Capture [ On ] (This prevents the "No records" message)

After the Perform Find step:

If Get ( FoundCount ) = 0

Exit Script

End If

Alternate: instead of the whole Find thing, use Go To Related Record based on a relationship to the number entered. If there is no related record, nothing happens.

Matt



On 01/20/2007 09:50:34 "Jeff Wright" <jeff (AT) jeffwright (DOT) demon.co.uk> wrote:

Hi Matt

Many thanks. Works a treat!!

--
Jeff Wright

"Matt Wills" <Im (AT) witz (DOT) end> wrote

Jeff Wright wrote:
an generalization of matt's step is to use
Get(LastErrorMessage)
and then you can test for what the error was (i think 401 is no found
records? ) and execute conditional scipts based upon the caputred
error...

best,
sg