Compare previous record to the new record
I am trying to compare previous record from the current record. Example:
If the customer ordered last 2011 and he would like to order again for 2012... The Renewal field should automatically put a "YES" since the customer is a renewal one.
Else if there is no order from the previous year then the Renewal status should be NO.
How can i do this?