Lookup different records, same last name

[Razzman]

This is similar to a previous post only different. I have database of contacts and a seperate DB of fax cover sheets/memos. I have a relationship using last names in the fax cover DB that automatically fills in the first name, company, and fax number for reference and printing. My problem is that I have several customers with the same last name (and not Smith either). As I've read and as happens, the Fax Cover DB only returns one "Smith" even though there are different records with different first names/companies. Any real simple ideas that a non-database person can grasp?

Thanks!

[Lee Smith]

Sounds like you need to change the relationship to include the first names. This would require concatenating your first and last name fields in a third field, and then using that as your key fields.

New Field Calculation result text

Your First Name Field & Your Last Name Field

HTH

Lee

[Razzman]

Hmm...This makes sense and seems pretty easy. Thanks!