Hi All,

How do i restrict my entry to only one cell that is i have 4 columns and i want my users to give value for only one of the four columns. something like a radio button which lets us to select only one.

I suppose this is possible but i am not aware of how to do it.

can anyone help me with this.

Thanks in advance.

Normally you do this with one column and an option group. The option group stores a number in the column that represents the choice. You can make only one choice.

So if you have a column in your table called "Choice", the option group displays 4 choices (or however many you tell it): "A", "B", "C", and "D". If the user selects "A", for example, 1 is stored in the column.

This sort of works like a look up function. Then you need to build all of your queries and code using 1 for "A", 2 for "B" etc.

So remove three of the columns you have, use one column and an option group instead.

HTH

mmcdonal