Data from portal row in merge field
I have a table, "Donations," which tracks amounts and dates of gifts for a nonprofit - these fields appear in a portal in my main table (based on Filemaker's template, "Contact Management"). Each gift generated in the portal row creates a new record in the donations table. I'd like a script that automatically enters the amount & date of the most recent donation in a form letter. The most recent donation shows up in portal row 1, because I have the portal set to sort by date descending.
Now I want the data from portal row 1 to go into a merge field in my form letter. How do I specify this?
Thanks in advance for your help.