Thanks Steve, can't think why I did not think to test BEFORE running the
GTRR.....

And to Winfried - it's good to know that both layout and the related table
found set remain unchanged if there are no related records.

Much appreciated input from the list once again.

Rgds
Peter

 

-----Original Message-----
From: FileMaker Pro Discussions [mailto:[log in to unmask]] On
Behalf Of Steve Moore
Sent: 22 June 2011 13:29
To: [log in to unmask]
Subject: Re: Go to related record

Hi Peter,

In your script, you can check to see if any related records exist with this:

If [ not isempty(RelatedTable::RelatedTableID) ]
   GTRR
   do your stuff
Else
   No related records exist
End If

HTH
--
Steve Moore
Cumberland, Maine


On Jun 22, 2011, at 6:26 AM, Peter Buchanan wrote:

> When using the Go to Related Record script step, is there a specific error
> code to look for with Get Last Error, for example if there are no related
> records? I am trying to figure out what happens if there are no related
> records :
> 
> I am using GTRR, and then importing the related records into another
table.
> How do I ensure only the related records (matching the current record) are
> imported? Will GTRR still go to the layout (in related table) specified in
> this command, even if no related records? Will the found set in related
> table be nil records if no related records, or will it comprise all
records?
> 
> Much appreciate any advice on checks to use with this script step.
> 
> Regards
> Peter