How to use two fields to select a unique record

[keysol]

My db includes an account number field and a loan number field. An account may have more than one loan. Detail records are created which are specific to a particular loan. So, how do I go about creating the necessary joins using two fields to define an "ID"
IE: Account: 10233 Loan 1 detail record 1
detail record 2
detail record 3
Account: 10233 Loan 2 detail record 1
detail record 2
Thanks,

Gérald

 

[itguy1]

Hi Gérald,

If you are looking for a unique "field" for account number and loan number to make up an "ID" try a calculated field with the formula: Combine(account,loan_num)

Good luck,

Mark

 

[suesloan]

You can join databases on more than one field too.

Sue Sloan