I have a main form with:
Center, Month, Amount, Loan ID
Subform:
Loan ID, Lender, Center, etc.
The subform loads the applicable list of loans based on the Center entered on the main form.
I'm trying to limit the Loan ID on the main form to the Loan ID list showing in the subform.
Each center has several loans. Each loan has monthly payment amounts.
I have tables for: Center list, Loan list, and Monthly payments
Center, Month, Amount, Loan ID
Subform:
Loan ID, Lender, Center, etc.
The subform loads the applicable list of loans based on the Center entered on the main form.
I'm trying to limit the Loan ID on the main form to the Loan ID list showing in the subform.
Each center has several loans. Each loan has monthly payment amounts.
I have tables for: Center list, Loan list, and Monthly payments