FMPRO-L Archives

June 2011, Week 4

FMPRO-L@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Jim Brear <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Thu, 23 Jun 2011 04:23:45 +1000
Content-Type:
text/plain
Parts/Attachments:
text/plain (41 lines)
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: [log in to unmask]
Web  http://www.coamas.com.au 
COAMAS - Community Options, Advocacy, Management and Accounting Software

-----Original Message-----
From: FileMaker Pro Discussions [mailto:[log in to unmask]] On
Behalf Of Peter Buchanan
Sent: Wednesday, 22 June 2011 8:26 PM
To: [log in to unmask]
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

ATOM RSS1 RSS2