relating 2 consecutive fields in a layout
I am developing a database for the assessment of pain in patients. One field I have set up has a drop down list of medical specialties. I would like the next field to list all the operations common to each specialty from the first list. How do I set up this second field to display a different list each time a specialty is chosen in the previous one?
All help gratefully accepted. a link to an appropriate thread would also be useful.