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

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