AnsweredAssumed Answered

Limiting member payment to last date paid

Question asked by BlyHartley on Jan 3, 2011
Latest reply on Jan 3, 2011 by BlyHartley


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!

Many thanks