> 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"}
|