find most recent invoice and record payment status

[shoil]

I'm working with a Domains database and an Invoices database. I need a script to locate the most recent invoice for each domain, then record the payment status (successful, declined, expired, etc.) in the Domains database. I understand Filemaker relationships pretty much, it's writing the script to find the most recent invoice that is baffling to me. This seems like it should be so simple. Shucks.

[jasonwood]

I think if you get information through a relationship, it always takes data from the first related record, so you just have to sort the relationship so that the most recent invoice will be first. You can specify a sort for a relationship in the "Define Relationships..." dialog box.

You won't need a script, just a calculation in the domains database that uses the sorted relationship to get to the relevent fields in the last invoice.

[shoil]

Thank you so much. This worked perfectly.

I've also used it to sort the records in a portal so that the most recent invoice is at the top of the list. Thanks again! ~~S