Hi there, I have a problem that I can't fathom out.
 
What I want to do is make a field so that it requires a value after a change in another field to a particular value. Is this possible with the ADD CONSTRAINT command, or will I have to make a custom function and use a trigger.
 
Many thanks
 
Nick