Look up a Patient's name

rhernand

Registered User.
Local time
Today, 02:59
Joined
Mar 28, 2003
Messages
96
I have a table with patient's data. I have made the key the LastName, FirstName and Telephone. How can I query a patient by putting:
1. a partial LastName, no FirstName, no Telephone
2. a LastName, a partial FirstName, no Telephone
3. etc.
 
What happens if you get a patient with the same name as another and neither has a phone number?

Col
 
Look up name

I am running the query from a form where the Lastname, Firstname and Telephone will be passed to the query. There will always be the case where multiple records will be brought back. i.e. only a partial LastName is inputted or like your case where two people have the same LastName and Firstname and neither have a Telephone. In this case i want to click on the name I want from the multiple result st can display that patient's info.
 
Thanks

Thanks, I think this is precisely what I need. I will give it a whirl and see what happens.
 

Users who are viewing this thread

Back
Top Bottom