Subject: | |
From: | |
Reply To: | |
Date: | Wed, 22 Jun 2011 15:00:50 -0400 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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: [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
--
Jonathan Fletcher
FileMaker 9 & 10 Certified Developer
Fletcher Data Consulting
[log in to unmask]
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
|
|
|