Stopping a field on a file from being changed

Hi everyone
We are on V7r3
I have been asked if there is a way to stop a field from being changed (updated) - except on certain conditions
I asked this question a while ago - and someone (forgive me - but I cannot remember who that was) suggested using a trigger
I am wondering if this makes sense - any and all comments gratefully accepted

Within the trigger program - on the file in question, on an update, compare the before and after values of that field
If they are the same - let it go
If they are different AND the conditions don't meet the exception conditions, update that record for that field ONLY within the trigger program back to the old value
This should trigger a secondary update trigger - but because the program updating the record is the name of the trigger program - let it go

If the conditions of the update meet the exception conditions - let it go

I hope this makes sense
As previously stated, any and all comments gratefully accepted




Alan Shore
Solutions Architect
IT Supply Chain Execution

[cid:image001.png@01D7004E.A31BDBC0]

60 Orville Drive
Bohemia, NY 11716
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
E-mail : ASHORE@xxxxxxxxxxxxxxxxxxxx

'If you're going through hell, keep going.'
Winston Churchill



The Nature’s Bounty Co. is now The Bountiful Company! Our email address will be changing from @nbty.com to @bountifulcompany.com. Please update your email address book so that important communications are not interrupted.