I would like to know if it's possible to have two fields (in this case bit
s) in the same table where one is prerequisite on another. For example Check2
may only be true if Check1
is true.
Note: I'm trying to implement a constraint in an attempt to accomplish this, but so far failing (I admit I have limited experience with constraints). This is a new database with little data, and there are no entries currently in the table where the conditions aforementioned are not true. That is, there is no record where Check2
is true.
For the record, I have spent a reasonable amount of time trying to find an answer to this, but I suppose I'm having trouble coming up with appropriate search terms if this has already been answered.
Aucun commentaire:
Enregistrer un commentaire