I have two fields that is populated by their respective pop up drop down of a value list.
Status Field and it's Status Value List
Need Field and it's Need Value List
The Data Entry person will update the Status Field which in turn affects the Need Field; 95% of the time, the Status Value List has a corresponding outcome on the Need Value List.
What I want is for FM Pro to automatically update the Need Field when the Status Field is updated but with the further option to manually change the Need Field after the automatic update if the Data Entry needs to do so.
If anybody can point in the right direction. That will be great.