Filtered Portal List

[Paul Chang]

Hi All,

I'm creating a patient database for multiple clinics ("Locations"). So, I've created two tables Patients and Locations. In the Patients layout, I have a pulldown menu that displays all of the available Locations. When a Location is chosen, Locations::Key field is tied to the Patient record by Patient::KeyLocation field.

Here is my problem. In the Location layout, I want to show a list of all patients whose Patient::KeyLocation matches that particular Locations::Key.

Here was what I thought would do this:

I created an equality relationship between Patient::KeyLocation and Location::Key. I then created a portal in the Location layout to display Patient records. Unfortunately, ALL patient records show up in each Location record. In other words, it is not filtering this list.

What am I missing?

Thanks in advance,

Paul

[Genx]

Have a look at your actual data in terms of the foreign key in your patients table.

~Genx