Hi

Is it possible to get two checkboxes to work as radiobuttons?

In our database some of the records may belong to one of two cathegories. A record can not belong to both cathegories at the same time. And most of the records don't belong to any of them.

Of course it's simple just to uncheck box A before or after checking box B, but it would be nice not having to think... Just checking box B and watch the the check in the A-box dissapeare. That would prevent errors when registering.

TIA

Anders

Hello Anders,

you can 'buttonize' your checkboxes and run a script that marks A while unmarking B.

I've made a lot of this tricks and they worked very fine; they are also an easy way to found records of the same 'family' using relations or finding functions or scripts acting 'goto related records'.

The better way to do this is to place on layout the two real fields you need to treat, then buttonize them and use a script to accomplish the proper job.

Have nice jobs.

[ June 16, 2001: Message edited by: JPaul ]

Could you not just set this one field to radio buttons?

Radio buttons work the way you describe the situation, namely, the record belongs to either this group or that group, or none (or even both - hold down Shift key).

Finding records for either category, or both, would be easy. Finding records that belong to neither would also be easy by using the "omit" feature and stacking your requests (find/omit cat 1, add new request, find/omit cat 2).

Sorry for not posting earlier. Have been away from all computers.

Thanks. The solution is of course not to use check boxes but radio buttons. The only thing is that I will have to place all the ordinary records in a "0-group" that is never called. If a record belongs to any of the specific cathegories they will be assigned to 1, 2 etc. The Shift-key option is a no-no in this case. The system will be used by people that may not know how to use this manouvre.

-Anders