many-to-many (linking fields from form to subform)

[canadaboy]

I searched and found a very helpful thread for understanding and working with many-to-many relationships. The database Pat Hartman attached to the following thread was very helpful:

many-to-manyDB

Now I have an additional question that I will base on the database attached to the aforementioned thread.

How could I add a command button to the "frmCustInfo" FORM that would open the "frmVenueInfo" FORM and limit the records to only those venues that involved the customer on the current record when the command button was pushed.

The problem I see is that the master and child linking fields are not on the same level (ie. the master is on the main form and the child is hidden in the embedded subform). Hopefully someone can make sense of my questions here.

Anybody?

 

[The_Doc_Man]

Look up the topic of Parent/Child linking, which appears in the help files under the sub-form topic.

Basically, a sub-form has some properties that define this linkage in the main form's sub-form control. (This is NOT found in the sub-form itself - it is in the control that is the sub-form's place-holder on the main form.)