MACSCRPT Archives

December 2006

MACSCRPT@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:
Bruce Robertson <[log in to unmask]>
Reply To:
Macintosh Scripting Systems <[log in to unmask]>
Date:
Thu, 7 Dec 2006 12:41:40 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (28 lines)
> I'm trying to read information from a series of portal rows.
> Applescript apparently knows nothing about related records. So, a
> Filemaker script:
> 
> Go to Portal Row [First]
> loop
> perform Applescript (read the cells and write to a file)
> Go to Portal Row [Next; Exit after last]
> end loop
> 
> I can see it highlighting one portal row after another, but it just
> reads the cells in the first row as many times as there are related
> rows. How do I get to read all related records?
> -- 

You're doing things the hard way. Ask directly for what you want, while in
the parent record.

tell application "FileMaker Developer"
    cell "Payments::DatePaid" of current record
end tell

Result - list of related data from the portal in portal row order:

{"6/11/2006", "8/6/2005", "7/17/2004", "6/27/2003", "7/5/2002", "6/15/2001",
"7/16/2000", "7/25/1999", "8/4/1998", "8/21/1997", "7/10/1996", "7/10/1996",
"1/20/1995", "1/20/1995", "8/24/1994", "7/26/1994", "5/31/1993"}

ATOM RSS1 RSS2