Structure for loans (1 Viewer)

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

tblLoan (Main Table)
LoanID
LoanDescription

tblApplicant (Primary Applicant)
ApplicantID
LoanID
FirstName
LastName
.

tblApplicantCo (Co-Applicants)
ApplicantCoID
LoanID
FirstName
LastName

Business Rule

There can only be 1 Loan file
There can only be 1 Primary Applicant per Loan file
There can be multiple Co-Appicants per Loan File

Can some please help me design this correctly, just looking at it make me think something is not right.

i think you just need your relationships now. the setup looks fine really. you have a way to identify all of the IDs. just make sure you JOIN them now with the relationship builder

Now in retrospect the idea of a co-applicant table will not work. Each applicant also has a link to a income, expenses, credit table. Each of these tables are joined to the tblAppicant by the applicantid. But if I go the route of the tbApplicantco, then I will have to duplicate the income, expense and credit tables for the co-applicant. There has to be a better way to do it.