Option Group Passing Data Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Simple question...I have 2 different option groups. I would like to pass
specefic data shen they are highlighted, or selected, instead of the general
-1. here are my examples:

Was the restaurant clean? [opt box]
If that is selected, then a 1 is sent. If it isn't, then a 0 is sent.

Other example:

What was your food buy?
[opt box] Chicken
[opt box] Fish
[opt box] Burger

If chicken is selected, then chicken is stored in the database, same as fish
and burger.

How do I pass this data when they are selected? Thanks!!
 
Dzirkelb

As far as I know, this is not directly possible with an Option Group.
The best approach is to use a Number data type field for this data, and
then, when you need it to show chicken etc for your purposes on reports
etc, use a calculated field ina quwery, using the Switch() function, or
alternatively make a little 2-column lookup table that shows the food
name and the corresponding option value, and use this in the query to
return the name. Hope that makes sense.
 
Back
Top