A simple drop down record search
So now thanks to the assistance I have received in the forum I have a nice database set up for a doctor's office. It has 3 tabs; one for the patient info(patients), one for visits(visits) and one for prescriptions(prescriptions). The Visits and Prescriptions tabs are portals.
What I would like is a dropdown on the Patients tab that would have the values of the patients Last Name, First Name and when a value was selected from the list that patient's record would appear.