I created a report that records entries from a table which has 4 columns
1 Shipper ID 2 SHipper Reference 3 loading 4 Completion
My primary keys are columns 1 and 2 there are no foriegn keys, columns 3 and 4 are mandatory fileds with a yes or no value constraint
what I want is to create a constraint that doesnt allow the user to pick these two fields (completeion and loading) as N in the same time but they can be both Y at the same time
what is the code for that constraint?
this code was my best shot
ALTER TABLE Table_Name ADD CONSTRAINT Double_constraint check (Completion!='N' and Loading!='N')
but this one wont allow anything but completion to be Y and Loading to be N