Creating multiple field links

[ep820]

I have a file that contains names & data on those names. The name is broken up into 3 fields, First Name, Last Name & Middle Initial. I then have other databases that I want to import data to, once the record is matched to all 3 of the fields FN LN & MI. I can only find that I can create a relationship to ONE field. Does anyone know how to create relationship to all 3, so when FN LN & MI match it will bring certain data into the other files?

[Kurt Knippel]

quote:

---

Originally posted by ep820:

I have a file that contains names & data on those names. The name is broken up into 3 fields, First Name, Last Name & Middle Initial. I then have other databases that I want to import data to, once the record is matched to all 3 of the fields FN LN & MI. I can only find that I can create a relationship to ONE field. Does anyone know how to create relationship to all 3, so when FN LN & MI match it will bring certain data into the other files?

---

Create a calculation field. cFullName = FirstName & " " & Middle Name & " " & Last Name

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

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

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

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