On Sep 25, 7:34 pm, Sandy <Sa...@discussions.microsoft.com> wrote:
> Hello -
>
> I have a table as follows:
>
> tblLoans
> LoanID PK
> DateEntered
> FileNumber
> LoanType
> etc.
>
> And another as follows:
> tblBorrowers
> BorrowerID PK
> BorrowerLast
> BorrowerFirst
> etc.
> LoanID FK
>
> These tables have a one to many relationship with tblLoans on the one side
> and tblBorrowers on the many side.
>
> When I join these tables, I need to just return one each of the Borrowers,
> regardless of whether or not there is one borrower or five borrowers for each
> LoanID. If there's more than one borrower, I only want the first one
> returned.
>
> How can I do this?
>
> Any help will be greatly appreciated!
>
> --
> Sandy

"Sandy" <Sandy@discussions.microsoft.com> wrote in message
news:D3987B9D-9B29-40E0-8264-7553442B5580@microsoft.com...
> Hello -
>
> I have a table as follows:
>
> tblLoans
> LoanID PK
> DateEntered
> FileNumber
> LoanType
> etc.
>
> And another as follows:
> tblBorrowers
> BorrowerID PK
> BorrowerLast
> BorrowerFirst
> etc.
> LoanID FK
>
> These tables have a one to many relationship with tblLoans on the one side
> and tblBorrowers on the many side.
>
> When I join these tables, I need to just return one each of the Borrowers,
> regardless of whether or not there is one borrower or five borrowers for
> each
> LoanID. If there's more than one borrower, I only want the first one
> returned.
>
> How can I do this?
>
> Any help will be greatly appreciated!
>
> --
> Sandy