Search results

I'm trying to set up a database to track inventory. The yes/no fields are: on hand, shipped, or wasted. Only one needs to be chosen but depending on which one is chosen it needs to require other fields. For instance if shipped is yes then the shipped to field needs to be required. If on...

I have a table with 3 yes/no fields. I need them to be dependent on each other meaning if one is yes the others can not be yes. How can I set this up?