I currently use an If statement that checks for the last error of 101 to detect if there are no related records before continuing in a script. Is there a better way to test for no related records in a script?

I currently do this:

Go to Related Record [show only related records; From table: ...]

If [Get (LastError) = 101]

Exit Script

End If

Continue on with script

Kind of a basic question, but checking for a general error number of 101 is kind of risky.

Thanks.

Yes, it is risky. There are issues with the error codes and GTRR. I prefer to check for related records before the GTRR.

If[Count(related_table::primary_Key)]

Go to related record

Else

Show Custom Dialog["There are no related records."]

Exit Script

End If

See this thread for an overview.

According the FileMaker's Jimmy Jones, the IsEmpty (relationship::key) test is optimized for this functionality.

I think I read this to say the same thing.

http://www.filemaker.com/help/FunctionsRef-311.html

Lee

Thanks guys! I'm going to update the scripts and sleep easier now.

Be careful with matching foundset GTRR, for which this won't work.

Also, ensure that all your privilege sets give access to destination layout. You can have related records without having the permission to GTRR.