Drop down search
I have a layout that we use to enter new employees. In excel we had a dropdown on the first name that you could search by and it would bring up all the information on that person. In Filemaker I tried to replicate this and it always wants to edit the existing record that I am viewing instead of going to the related record that i selected from the dropdown. Any ideas on how to do this?