I have three fields:
I need to make sure that the combination of WaterTemp and Units is within -10.0 - 50.0 °C.
WaterTempCelsius is a calculated field with the following Calculation:
WaterTempUnits = "Celsius";WaterTemp;
WaterTempUnits = "Kelvin"; WaterTemp - 273.15;
WaterTempUnits = "Fahrenheit"; ((WaterTemp-32)/1.8);
I turned off Indexing in hopes that would cause it to always calculate.
The Validation for WaterTemp is:
WaterTempCelsius ≥ -10 and WaterTempCelsius ≤ 50
I added a Message that states the range it is supposed to be. I have the "Always" checked for Validate in this Field and not allowing user override.
When I put in a WaterTemp that is within the range in Celsius (say 0) and have the units set to Celsius. I do not get an error.--GOOD
When I put in a WaterTemp that is within the range in Celsius (say 0) and then CHANGE the units to Kelvin (result -273.15 °C). I do not get an error.--BAD
When I modify the WaterTemp with the units selected it validates.--GOOD
How do I make sure the validation is run if I change the Units?
I've only had FileMaker for 4 days, so be gentle.