HELP Form with SubForms

D

dee

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.
 
D

dee

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top