Hello,
I am making a database that is used to enter Quality Control data. In order to prevent erroneous entries, I am setting up validation rules (for example the measured pH has to be between two certain values). This is easy enough to do when those numbers are fixed, but I want those to be able to be changed easily. Since there are several tables that have the same bounds, I want to have one place where they can be changed and have it update to all of the necessary tables.
For example, I tried making a Bounds table with fields such as pHMin, pHMax, etc. I want the validation rule to be able to say something like:
"Between Bounds.pHMin and Bounds.pHMax"
Then when I go to the Bounds table I can put in any value I want for pHMin and pHMax and have that validation rule use those values. Unfortunately, this doesn't work. Is there a way to get Access to do this? Thanks in advance for your help.