4 Replies Latest reply on Nov 26, 2010 10:37 AM by rmen

    relating 2 consecutive fields in a layout

    rmen

      Title

      relating 2 consecutive fields in a layout

      Post

      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.

      Ram