I want to compare fields from two files

[Patty Stoddard]

I want to reconcile fields from two different sources that have the same
field names. Both files have the following fields that I plan to import to
separate tables:
Social Security number
Last Name
First Name
Loan ID
Disbursement ID
Disbursement Sequence Number

How do I assign a key to these tables once I import them when the only thing
that distinguishes on record from another is a combination of the Loan ID,
disbursement ID and Sequence Number?

 

[Patty Stoddard]

I think I know the answer to my own question. I need to designate all fields
that make the records unique as the primary key - and then do an unmatched
query.