How to have contents of one field automatically dictate contents of another field
I'm using Filemaker Developer 7.
In my health database, amongst all the fields, I have two pull-down fields that I want to have related to each other -- (the names of the patients, and the illnesses they experience).
How can I have things work so that if I select a particular patient, then their corresponding illness will automatically be shown in the other field?
Does it require a script? If so, what might I do?
I tried exploring the "relationships" menu but couldn't figure out how to use it or whether it was relevant.