HELP Form with SubForms

[Guest]

Hi,

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 hope I've been clear enough. This group has been so helpful and I've
tried very hard to work through this on my own, but am banging my head
against the wall!

Thanks so much.

 

[Guest]

Just to clarify previous post. What I want to achieve is:

Main form - Family Name and ID
Sub form 1 - PaymentID, Date, Amount, Mode, Cheque No
Sub form 2 = PaymentID (I guess) then be able to choose Student Name from a
combo box that limits it to the students related to the FamilyID in Main
Form. I also want a combo box that, again, shows only the courses the
specific student is taking. (This information is in the Enrollment table)

I have no idea how to accomplish this. I know how to create the combo box,
but where to I take the fields from and to.