Subject: | |
From: | |
Reply To: | |
Date: | Thu, 23 Jun 2011 07:09:15 +1000 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
I think Jonathan is right. If it is an automated process you only need to
know related records exist.
Counting the records is ok if you need some visual confirmation but would be
slower.
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 Jonathan Fletcher
Sent: Thursday, 23 June 2011 5:01 AM
To: [log in to unmask]
Subject: Re: Go to related record
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
|
|
|