Trouble with tables

[jhahes]

Can someone please help me, I might have my logic a little backwords.


I have a table (tblLoanDetails)

LoanNumberID
etc.
etc.
etc.
EscrowCompanyID


then I have a table called (tblEscrowCompanies)

EscrowCompanyID
EscrowCompanyName
EscrowCompanyAddress
etc.
etc.
EscrowOfficerID

then I have a table called (tblEscrowOfficers)

EscrowOfficeID
EscrowOfficerName
EscrowOfficerSalutation
EscrowOfficerEmail


What I am trying to do is when someone is filling out the first table (tblLoanDetails) they have a dropdown to choose the escrow company, then they must choose the escrow officer

Each escrow office can have many officers, however, when they choose the escrow officer from a dropdown, I only want that offices escrow officers to appear in the dropdown.

Any help would be greatly appreciated

thank you

Josh

 

[RuralGuy]

Have you searched this site for "cascading comboboxes" yet?