Have created a correspondence data base related to a contact data base. The idea is to write letters and get the pertinent address infor from the contact DB. The shared link is "last name". The problem is when I put in a common last name such as "Smith" the correspondence DB only gets the info on the first "Smith" in the contact DB. How do I make it so I have a choice of which "Smith" to use.

quote:

---

Originally posted by rvivian:

Have created a correspondence data base related to a contact data base. The idea is to write letters and get the pertinent address infor from the contact DB. The shared link is "last name". The problem is when I put in a common last name such as "Smith" the correspondence DB only gets the info on the first "Smith" in the contact DB. How do I make it so I have a choice of which "Smith" to use.

---

Relate the records via a ContactID, that is an ID that is UNIQUE to each contact. A simple qay to pick the contactID is via a value list, so that you can show a couple of fields to help determine which contact you want.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=