Getting Last Donation For A Contact

[etsmarines]

I have a donations table and a contact table. The donation table tracks donations by date, amount, event and links them to their appropriate donor by contact id.

I am creating a letter writing program that I can insert a merge bracket and it will automatically include the appropriate contacts last donatio amount. The problem is i dont know how to create field that calculates what the amount and date of the last donation was automatically.

Does anyone know how to do this?

Thanks!!

Erik

[David Jondreau]

Sort the relationship by date descending and create a calc field that pulls from the related table.