>Hi everybody,
>
>How can I make two bit fields to be mutually exclusive? E.g. I have Approved and OnHold fields and if OnHold = 1 Approved should be 0. If OnHold = 0 Approved still can be 0.
>
>Thanks a lot in advance.
And why you need TWO fields for ONE status?
Why not one tinyint:
0 - No processed yet.
1 - On Hold
2 - Approved
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.