filters

C

Chris

I a table that has loan numbers and errors for each loan
number. Some loan numbers have more than one error.

In my main form I have a sub form. The main form lists the
loan number information. In the sub form I list the
errors.

If the loan has 3 errors how can I reduce scrolling each
incident on the form since I already have all of the
errors listed on the sub form?

Thanks for your help

-Chris
 
D

Dirk Goldgar

Chris said:
I a table that has loan numbers and errors for each loan
number. Some loan numbers have more than one error.

In my main form I have a sub form. The main form lists the
loan number information. In the sub form I list the
errors.

If the loan has 3 errors how can I reduce scrolling each
incident on the form since I already have all of the
errors listed on the sub form?

Thanks for your help
Click to expand...

I don't understand that last sentence of yours:
If the loan has 3 errors how can I reduce scrolling each
incident on the form since I already have all of the
errors listed on the sub form?
Click to expand...

Is your main form based on the same table as the subform, such that the
main form has three records for the loan number if that loan has three
errors? You ought to have a table of Loans, with one record per loan,
and another table of LoanErrors, with one record per error per loan. Is
that what you have?
 
Top