Newbies Jennifer Posted November 12, 2020 Newbies Share Posted November 12, 2020 Hi everyone. I am new to this forum, so I hope I am posting in the right spot. I created a database for my company at work. On multiple screens I have a patient lookup. The relationship is patient table: last name = insurance table: last name lookup. The lookup is a drop down that shows patient last name and first name and then pulls other corresponding information when selected. The lookup works, however it only pulls one record. Example. If I have multiple patients with the same last name like smith only one smith shows up in the box. I need all the smiths to show up to pick the right patient. It seems like it should be such a simple thing but it isn't pulling the records. I did check the patient database and yes all the records are there. I also checked that I have selected the all records option in the relationship box. I am using filemaker 17. Can anyone help me or have you seen this issue before. Thank you very much. Link to comment Share on other sites More sharing options...
This topic is 934 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 account
Already have an account? Sign in here.Sign In Now