Don't count them just to decide whether to go there. Steve's If step is sufficient:
> If [ not isempty(RelatedTable::RelatedTableID) ] All you care about is that there is at least one. This will give you that answer. Counting related records, especially if it's a large related set, is a time waster. j. On Jun 22, 2011, at 2:23 PM, Jim Brear wrote: > Hi Peter > > In circumstances such as yours I would set up a calculated field to count > the number of records in the relationship Count (Table::Field) and test > that the result is >0 before invoking the import steps. > > Best Wishes > > Jim Brear > COAMAS Services > PO Box 1542 Armidale NSW 2350 > Mobile Phone: 0429 428 700 > Home Office Phone: (02) 6772 3933 > Fax: (02) 6771 3666 > email: [email protected] > Web http://www.coamas.com.au > COAMAS - Community Options, Advocacy, Management and Accounting Software > > -----Original Message----- > From: FileMaker Pro Discussions [mailto:[email protected]] On > Behalf Of Peter Buchanan > Sent: Wednesday, 22 June 2011 8:26 PM > To: [email protected] > Subject: Go to related record > > 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 -- Jonathan Fletcher FileMaker 9 & 10 Certified Developer Fletcher Data Consulting [email protected] http://www.fletcherdata.com 502-509-7137 Kentuckiana's FileMaker Users Group Next meeting: June 28, 12:00 pm to 3:00-ish Listserv signup: http://fmpug.com/mailman/listinfo/louisville_fmpug.com Blog: http://www.kyfmp.com
