Hey,
I have a form with a few fields.
The form is designed for entering patients' lab results into a table.
In another table (tb_parameters) I have fields for parameter, unit_type (mg, dL etc.) min (minimal acceptable value) and max.
I use a combo box based on this table in order to chose the appropriate parameter.
My problem is - I wish to have some validation rules based on the min and max values of each parameters (so that the user won't enter unreasonable values by mistake)
I've designed a query which takes the entered parameter from the form and returnes its unit, min and max, but when use it as the source for the validation rule I get an error (maybe because the validation rule doesn't run the query).
Any advice ?
I have a form with a few fields.
The form is designed for entering patients' lab results into a table.
In another table (tb_parameters) I have fields for parameter, unit_type (mg, dL etc.) min (minimal acceptable value) and max.
I use a combo box based on this table in order to chose the appropriate parameter.
My problem is - I wish to have some validation rules based on the min and max values of each parameters (so that the user won't enter unreasonable values by mistake)
I've designed a query which takes the entered parameter from the form and returnes its unit, min and max, but when use it as the source for the validation rule I get an error (maybe because the validation rule doesn't run the query).
Any advice ?
