Change a field for one user
How to properly do the following?
We share a database on FM Server11. On a particular layout we show machine cost & profit margin. From time to time we may have a customer stand over our shoulder to watch what we are doing and it becomes tough for him not be able to see cost & margin figures. I am wanting to have the user select this "Customer View" field which would be a "Yes" or "No" so as to hide the cost & margin fields (via conditional formatting) if the users so desires.
The trick would be for this option to change on to a "Yes" or "No' only on his view & not for all of our users if they are looking at the same record.