Limiting member payment to last date paid
I am new to Filemaker, but have used Foxpro and Access extensively. I am not sure of the exact terminolgy FM uses so I will stick with generalities for my question.
Two tables: Members and Payments. They are related by MemberID.
For each member there are many payments and each payment record has a type: (Renewal, Return, New). I need to limit my report to show only the LAST payment date for each member (max(Paydate) AND the type of Payment made on that date.
Any guidance? I have tried everything I can think of and have now landed here asking for help!