Selection on a Value List triggers a date, help
We are using FMP10
I have a value list that is a very important value list in our database. The value list has different events and as one key event is selected in the value list, I want the selection of a specific value in the value list to trigger the entry of a date in another field. However, as different events are selected on the value list, I do not want the previously entered dates to be modified. Here is a simplified summary of what the value list looks like:
Now when "Concept Approved" is selected, I want the field that is titled "Concept Approved" to have the date of when "Concept Approved" was selected. However, as other values are selected on the value list, I do not want this date to change. There are other dates that I want to be triggered by the value list, like "Pre-Production Approved". How do I write a calculation for this?