AnsweredAssumed Answered

How can I get the last value record

Question asked by AllanMagsino on Aug 1, 2011
Latest reply on Aug 1, 2011 by AllanMagsino


How can I get the last value record



I am new to filemaker and I have a question. Here is the scenario....I have a field Subscription Type and Renewal. The Subscription type value list are usually Full Year 2011, 3Months Subscription 2011, Full Year 2012, 3 months Subscription 2012 and so on. 

If the customer ordered last Full Year 2011, and trying the order for 2012.Once I selected Full Year 2012, the Renewal field should automatically put a YES otherwise NO.

How can I get the last value from the previous transaction of the customer so that the Renewal field will automatically populate the answer?

Note: The subscription is in Text format.

Thank you so much