Hi All,
I have a small problem which I have so far been unable to solve. I am
working on someone else's database which needs to ensure that certain fields
are filled in if the value of other certain fields values are not null.
Sounds simple enough however, I need to apply 2 validation rules to the same
table.
Both validation rules separately are:
([return or refused] Is Null) And ([vehicle spec] Is Null) And ([QC
problem] Is Null) And ([late] Is Null) And ([DNA] Is Null) And ([mixed
loads] Is Null) And ([extra deliveries] Is Null) And ([VCP's] Is Null)
And ([barcode/swing ticket] Is Null) And ([box end label] Is Null) And
([set labels] Is Null) And ([shrouds] Is Null) And ([Boxes] Is Null) And
([hangers] Is Null) Or ([ref] Is Not Null)
([return or refused] is null) or [qty_refused_or_returned] is not null)
Is there a way I can combine the 2 together without having to re-design the
database structure which I would prefer not to do?
TIA,
Mark