Linking Radio buttons for Auto Entry
Hi. I'm using FileMaker Pro to design a database for the first time (version 11). Please help me with this:
I need to link two sets of radio buttons.
Let's say that field A has values "Normal" and "Abnormal" and fields B, C and D have possible values of "disease present" or "disease absent".
I have set A to auto-enter "Normal" unless specified otherwise.
If the radio button "disease present" is selected for even one of the fields B, C or D, I want A to auto-change to "Abnormal".
Do I use script or auto-calculation?
How do I do this?