Newbies Paul Chang Posted February 24, 2006 Newbies Posted February 24, 2006 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 Posted February 24, 2006 Posted February 24, 2006 Have a look at your actual data in terms of the foreign key in your patients table. ~Genx
Recommended Posts
This topic is 6855 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now