Reliant Subforms

[ImBatman]

Hi

Is anyone aware of a method to have two subforms on a form and then set the sub forms up like this:

Form1 is the main form
Subform1 is dependent upon the Key field in Form1 (can get this far easy)
Subform2 is dependent upon the Key field in Form1 + the Key value in Subform1?

In my example I have Attendees (main)
who can belong to a long list of Agencies (and Agencies make up a table on this form with a whole bunch of fields)
then for each Attendee, depending upong which Agency they belong to, I need to list a table of data about the Sessions they are attending.

It may seem trivial, but I have been racking my brains and bandwidth trying to work it out.

Thanks.

 

[MStef]

Hello Batman!
Put Subform2 as subform in Subform1, than both subforms
as one subform in MainForm. In that case Subform2 is linked on Subform1, and on MainForm via Subform1.