Lookup Problem with same values
I'm doing a lookup to pull information from a Contacts Database into the current database.
The matching fields for the relationship are the contact names.
When I enter a contact name it pulls in the persons email, mobile, phone and fax numbers.
Everything works fine for the most part but when there are a number of contact names the exact same (e.g two John Smiths) the lookup always picks the first John Smith it encounters in the Contact names database and pulls in their information.
How can I get the lookup to pull in the information from the correct record in the Contact Names Database