How to get the previous or last record

[MagsinoAS]

Hi,

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.

Allan

[LaRetta]

Hi Allan,

I hate to say this but I suspect your structure is lacking a critical table where each individual entry is a record. A clue to the problem is "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."

Would you be willing to provide your file for structural review? Just as in building a house, a solid foundation is the most critical and there are folks here with extensive expertise willing to guide you towards good design.