AnsweredAssumed Answered

Lookup Problem with same values

Question asked by jdun on Feb 24, 2009
Latest reply on Feb 25, 2009 by davidhead


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