4 Replies Latest reply on Jan 3, 2011 12:57 PM by BlyHartley

    Limiting member payment to last date paid

    BlyHartley

      Title

      Limiting member payment to last date paid

      Post

      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