Help! I'm stuck.

[Guest]

Scenario: - Create a database for commercial lenders. Each commercial lender
would offer various loan types and various property types.
- Create a user-friendly form with multi-select two list
boxes (one for loan type and one for property type), "and" and "or" option
buttons and a command button to run the query.

Tables created:
1) tblLenderMaster - contains info about the lender
Lender ID (primary key)
Lender Name
Contact
Phone

2) tblLoanType
Loan Type ID (primary key)
Loan Type

3) tblPropType
Property Type ID (primary key)
Property Type

cross reference tables:

4) tblLenderLoanType
Lender Loan ID (primary key)
Lender ID (foreign key)
Loan Type ID (foreign key)

5) tblLenderPropType
Lender Property ID (primary key)
Lender ID (foreign key)
Loan Type ID (foreign key)

Relationships created:
tblLenderMaster - tblLenderLoanType (Lender ID)
tblLenderMaster - tblLenderPropType (Lender ID)
tblLenderLoanType - tblLoanType (Loan Type ID) join type 2
tlblLenderPropType - tblPropType (Property Type ID) join type 2

Ultimately, the user has to select the loan type/s and property type/s in
each of the list boxes, choose one option button, then run the query and show
which lenders would fall under the category chosen.

I assigned a string for each of the list boxes chosen and also for the
option button. I am not sure if i designed my form correctly and if my
variables are right. I am having trouble with the SQL code for the run query
command button.

I'm just a new user and I'm stuck. Please help.

 

[Guest]

If you are still having problems, email me the database and explain the
problem.
covrambles at yahoo dot com