Form ---> SubForm1 ---> SubForm2 ? 1

[johnfrani]

I have 3 tables:
tblCase: CaseID, CaseNo, Date
tblPerson: PersonID, CaseID, Name
tblCharge: ChargeID, PersonID, Charge

tblCase (1) --- (Many) tblPerson (1) --- (Many) tblCharge

I have 1 form and 2 subforms:
frmCase - with Tab Control
sfrmPerson - on Tab2
sfrmCharge - on Tab2

I want to have frmCase data on Tab1 and sfrmPerson and sfrmCharge on Tab2 so for each Case I can see the people involved in that case and each person's charges.

I know how to create frmCase with subform sfrmPerson.

How do I synchronize sfrmCharge with sfrmPerson?
When I try to add sfrmCharge, the wizard wants to link it with frmCase.

I believe the solution has something to do with the Source Object, Link Child Fields and Link Master Fields properties of the sfrmCharges control - but I don't understand the concept.

Help!

John

 

[Remou]

I think this is similar to the Customer Orders form in the Northwind.mdb sample database. In this form, the links are set:
[tt]Link Child Fields: OrderID
Link Master Fields: [Customer Orders Subform1].Form![OrderID][/tt]
Which might read on sfrmCharges:
[tt]Link Child Fields: PersonID
Link Master Fields: [sfrmPerson Subform Control Name].Form![PersonID][/tt]