I have recently imported a lot of records into a new format database. This means some fields that from now on I would never like left empty, are empty. This is fine on individual records, as we are working through and filling them in.
However, because I have these fields on subtables as well, it is proving almost impossible to edit a record, as when I do, I flags 10 other records that need “Not Empty” fields completing in the subtable.
I know I could just turn off the “Not Empty” option until these are all completed, but I was wondering if their was a way the “Not Empty” condition could apply in the main sheet but not in any subtables?