Using a drop down list to display two sets of data

Hi, I have been fiddling around with for a week or so now. So far I’ve managed to slowly figure out everything I need to, but am still having trouble with one last major thing.

I have a page with a drop down menu on it (calling names from a database), that menu then populates a group of fields underneath it (from the same database), but I also want it to populate a second group of fields that will show data from a second database related to the name from the drop down.

The page in question is “patient_lookup”
The drop down calls names from “patient database”
The field underneath the drop down calls details from “patient database”
And I want the field on the right side to populate with information from “incident database” depending on what name is selected.

Any thoughts?

This topic was automatically closed after 70 days. New replies are no longer allowed.