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

I am trying to properly design a table with the following structure:

tblLoan (Main Table)
LoanID
LoanDescription

tblApplicant (Primary Applicant)
ApplicantID
LoanID
FirstName
LastName
ISPrimary

Rand605,

Not much to go on...

I am assuming you want to a database to track Loans? Then you actually need 
three tables.  One for Loans, one for Applicants and the last one for Loan 
Applicants as more then one applicant can be on a Loan Application and an 
Applicant can have more then one loan (ie... Mortgage - Spouse1 and Spouse2, 
Car - Spouse1 or Spouse2, Boat - Spouse1 and Spouse2)

tblLoans
lLoanID (PK)
lLoanDescription

tblApplicants
aApplicantID (PK)
aFirstName
aLastName
aISPrimary

tblLoanApplicants
laLoanID (FK)
laApplicantID (FK)

-- 
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors 
II

http://www.regina-whipp.com/index_files/TipList.htm

"Rand605" <u56649@uwe> wrote in message news:a0095dd082afe@uwe...
> ------------------------------------------------------------------------------
> --
>
> I am trying to properly design a table with the following structure:
>
> tblLoan (Main Table)
> LoanID
> LoanDescription
>
> tblApplicant (Primary Applicant)
> ApplicantID
> LoanID
> FirstName
> LastName
> ISPrimary