Current Date = Expiration Date
Data base is on Windows XP and using FM Pro 9 Advanced setup on IWP
I have a value list (Field name "Status"). The value list has a dropdown list with the terms Active, Pending, Sold, Cancelled, Withdrawn, and Expired. I also have a date field with the Expiration date previously entered. How can I have the Status field automatically change from ACTIVE to EXPIRED when Current Date = Expiration Date.
I would also want it to change Contingent to Expired on the = date
And Pending to SOLD on a given date