Return to FileMaker.com
I am new on databases and Filemaker. I would like some help to create a list so I can set a number value to each text variable on a list.
For example, when creating a categorical variable like Female or Male, I would like it to appear instead as 1 or 2.
Thanks for your help.
Create a table with two records. one field is text with "Male" and "Female". Another is number with 1 and 2.
Set up a use values from field value list and specify the number field as field 1 and the text field as field 2. Select the option that only shows values from field 2.
Retrieving data ...