mutually exclusive buttons/fields

[Pyorkie]

Hi

Haven't been on for a while. I have a question. Does anyone know how to create mutually exclusive buttons? I have 2 buttons/fields that have 2 different value list attached. I would like to be able to click on one of the buttons/field and to have the other buttons/field become inactive and visa versa and to then reset to both active in the next record so that I can then choose again.

If I click  buttons/field (1) I want  buttons/field (2) to be inactive and if I click  buttons/field (2) then  buttons/field (1) to be inactive but when I create a new record then both are available to choose again.

Please forgive me but I am still learning , I am sure a script would be required but I don't have that type of expertise and I have exhausted all the help files and can't find what I am after.

Any help would be much appreciated. This is a personal project (actually for my wife).

 Cheers! 

pyorkie

[bcooney]

Can you describe the scenario rather than the technique that you might not really need. It doesn't sound like a well-structured data base.