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:
Jonathan Fletcher <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Wed, 22 Jun 2011 15:00:50 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (69 lines)
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

ATOM RSS1 RSS2