Option Group Value Question: Non-Numeric?

[nico]

I have a form for users to enter data into a table. The form has an option group (option buttons) with 2 choices: Scheduled and Unscheduled. The value for Scheduled is "1" and Unscheduled is "0". Everything is working fine, I just have a question about possibly changing the values. I have a report that displays results of the inputted data and I would like to have something meaningful display to users who are reading the reports. In other words, the users will not know what "0" or "1" means. So, I tried inputting text values instead of numeric but it does not seem to allow it. I know I could use a combo box instead, but I would prefer to use the 'radio button' (option button) display for my form. I'm not sure what else I could do. Is there a way to have a separate field in my table that would display different text depending on the value in my scheduled/unscheduled field? For example: (if [Scheduled/Unscheduled] = 1, "Scheduled", "Unscheduled"). But I'm not sure how to accomplish this. Thanks for your help!

 

[SydneyGeek]

There's a couple of options. One is to build a lookup table with 2 fields: OptionID and OptionDescription.

To show the "readable" values, link this table to the field from the option group and use the lookup table deecription instead.

Denis