I want to set a validation rule that allows values in a specific field to limit the values entered in another (same table). For example, numbers in Field B must be within 10 of numbers in Field A. So if Field A has 40, the value of the corresponding Field B record must be 50 or less. So the validation text would popup and state "Field B value must not exceed 10 of Field A value".
Hope it is understandable, thx in advance for input.![]()