Hi John,

You have helped me incredibly in the past and I have been trying to post
generally and working on my own with Access, plus reading books, etc. You
have been so generous with your advice and I didn't want to become a pest,
but... I'm at the end of my rope of this one.

To refresh your memory, I have the student database.  The area where I'm
having trouble is the payment and deposit data.

For Payments:

I would like to create a form with 2 subforms that would populate the
following tables:

*Payment Information Table:
PaymentID - autonumber PK
FamilyID - FK from Family Info table, one-to-many, referential integrity
enforced
Mode (cheque or cash)
Date
Amount
Cheque no

*Payment Allocation Table:
PaymentID - FK from Payment Info table
CourseID - FK from Course Info table
StudentID - FK from Student Info table
- These three fields are the PK of the table
CourseName - will use a bound combo in form to look up from Course Info
StudentName - will use a bound combo in form to look up from Student Info
Amount - will key in amount from Payment Info table

The payment may be split.  For example, a payment of $200. may be split
$50.00 for child A in the family per course for a total of $100. and the same
for child B.

I create a form using the wizard that includes the family name from the
Family Info table, plus the fields from the Payment Info.  No problem.

The problem arises when I try to create a sub-form and drag it into the
design of the form I mentioned above.  I can get the student name combo box,
but it shows the names of all students, not just the ones for the family
involved, I can't seem to tell it which family it should be linking to.

I also will have to populate a Deposit Info table (this means bank deposits
of the money taken in) that will contain the total amount deposited per
deposit number, broken down to total cash deposits and total cheque deposits.
I haven't even attempted this, because I'm struggling with the above.

I hope this is clear enough.  Any assistance you could provide would be
greatly appreciated.
Thanks so much.