This indicates that your database is doing exactly what you designed it to do, but that it is not doing what you want it to do.
Validation options evaluate at the data level. So as you have discovered, they kick in for every new record in a given table no matter what layout you are on at the time.
There are a number of alternative approaches possible, but I'd need to know a lot more about what you are trying to do before I can suggest an alternative.
WE are asking a caller if they give their consent to continue an interview. I built a layout for a specific project and I added a field in the table named "1315 consent" (where 1315 is the project number).It's very important that we get the persons consent to continue so that's why I tried to make it a mandatory (not empty) field.
This will work well moving forward...but all of your past records prior to adding that field and validation have no value in the field. Do a find for the empty ones.
If you mandate that the field be not empty..you have to put a value in all of the existing empty ones. That value can be "no consent" or anything else...it is your old records causing you the issue.