> > 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"}
Maybe that works in Filemaker Developer, but it doesn't work for me
in Filemaker 8. Perhaps in 8.5?
--
Bill Steele
[log in to unmask]
|