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