Using a two choice option on a table

[Lou_Reed]

I am creating a two choice option in a form for an employee to either be a government employee or a contractor. This is like a Boolean except that
the choices are gov or contr, not yes or no.

I am unsure how to do that. When I go the controlling table, the choice it offers me is a yes or no (or in this case a checkbox), not two other mutually exclusive choices such as gov or contr.

So going to the controlling table in design view how do I make to two choices sort of black and white, not yes and no?

I could say something like gov label, and the option yes or no with the implication if they are not a government employee they must be a


contractor. I just do not think that looks very good.

How may I do the better job?

Any help appreciated. Thanks in advance.

Respectfully,


Lou Reed

[aytee111]

Option Groups are form-related, nothing to do with tables. If you wish to store a value from a form in a table then add a column to that table. It can be any data type, text or whatever.

Use the wizard to create the option group, set the values you want, and if it is bound to a column in a table then make sure that it matches (yes/no, text, etc).

[pbaldy]

I'd use the option group aytee mentioned, bound to an Integer field (I think an option group can only have a numeric value, though I could be wrong). I'd also have a table to drive the choices with two fields, the numeric value (1,2) and the text value (Gov, Con). You can join that table to the main table to get the descriptions, and it makes it more dynamic if you need to add a third choice later.