Trigger update one field when another field is modified

[jnichel]

Hi, we're running FM8.5 here, and it has been thrown into my lap when the person who had a basic understanding of it left our company. My knowledge of what can and can't be done with FM is extremely limited (I'm a SysAdmin by trade), so please bare with me.

In one of our tables we have a field called 'order_status', on the layout, it is in the form of a drop down box. What I'm looking to do is populate a second field called 'Process_date' (in the same table), with the current date, when 'order_status' is set to a specific value (in this case, 'Paid'). I know how to do this with the likes of MySQL, Postgres, etc, but have come up empty with trying to figure it out for FM (I must not be asking Google the right question ). Is this possible? If so, can someone point me to a resource on this topic? TIA

Edit: Sorry, I didn't notice until after this posted that the "Server Forums" are only for FM Server 9 and up.

Edited January 8, 2009 by Guest

[aldipalo]

Click File->Manage Database

Choose the table that contains the 2 fields.

Highlight 'Process Date' and click on options.

Click the Auto Enter tab.

Click auto enter calculation.

enter the following:

Case(Order_Status="Paid";Get(CurrentDate)

Click 'OK' and the uncheck "Do Not Replace Existing Value."

hth

[jnichel]

This worked perfectly, TYVM.