disabled fields

[tawatana]

hi,

i was wondering how i could disable a field by having the user select a radio button option.

For example, i'd like to have a group name field and individual name fields. There is a radio button group with the options being either group or individual. If the user selects the group radio button then the individual name fields are disabled and vice versa.

Thanks

Brian

[Pupiweb]

The most elegant way of doing this is usinmg the so-called "visibility" trick (look for such a file at http://www.databasepros.com)

Basically:

You have a RecordID field, unique

Create a calc field

Case (RadioButton = "Individual", RecordID)

In plain english: if the user chooses "Individual" in the radio button field return the RecordID, else nothing

relate the calc field to RecordID in the same file

Place a one line portal of this relationship in the layout and put the Individual names field in it

In action: when the use selects Individual in the radio button field the self relationship is valid, and the Individual names field appears on the layout, otherwise the field is simply absent from the layout

Great interface technique !

[tawatana]

cheers mate!

you've helped to open up a whole new world.