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
