Hi there,
I am developing a medical patient database for out research group. We have agreed to store numerical values in the table to help running statistics later. however, in the input form, we have to give text options.
For example, I would like to create a form to save maternal medical history. The first field is gestational diabetes. This field can have the numerical values 1, 2 and 3, which would mean:
1: Yes
2: No
3: No data.
Now, I have managed to create a combo box with the Yes/No/No data options, I just don't know how to write a script/code, which would assign the numerical values to the options and save the appropriate number to the appropriate field in the table.
Sorry, if I'm being impossibly amateur
Thanks,
Aron
I am developing a medical patient database for out research group. We have agreed to store numerical values in the table to help running statistics later. however, in the input form, we have to give text options.
For example, I would like to create a form to save maternal medical history. The first field is gestational diabetes. This field can have the numerical values 1, 2 and 3, which would mean:
1: Yes
2: No
3: No data.
Now, I have managed to create a combo box with the Yes/No/No data options, I just don't know how to write a script/code, which would assign the numerical values to the options and save the appropriate number to the appropriate field in the table.
Sorry, if I'm being impossibly amateur
Thanks,
Aron