Master/Child between Subforms

[Pilotwings_64]

Let’s say that A is the mainform. B and C are subforms each within A. Neither B nor C are subforms within the other. Is it possible to create a Master/Child relationship in which a field within B is the Master and a field within C is the child?
If so, is it possible to accomplish this if both B and C are displayed in Datasheet view?
Thanks,
Justin

[ajetrumpet]

Is it possible to create a Master/Child relationship in which a field within B is the Master and a field within C is the child?

NO. why would you ever want to do this anyway?

[Pilotwings_64]

GalaxiomAtHome from Microsoft Access Help Center (http://www.access-programmers.co.uk/forums) offered this solution.

“Place a textbox on the mainform with the control source as the subform field you want as the Master (=Forms!mainform.subformB.Form.fieldname). Then set this textbox as the MasterLinkField of the other subform control.”

I tried, this and it linked the text box to the desired field in subform B but I can’t find a way to link subform C to that text box using a master/child relationship.

Does anyone know how I can complete this final step?

Thanks again,
Justin

[Pilotwings_64]

mike60smart at UtterAccess.com walked me through the process. The thread has the same name as this one (maybe I named it Parent/... instead of Master/...).

Basically, I just had to do the master/child linking in the properties panel, by tying the links in, since the dialog box and dropdown menu were not offering me the option of selecting any of the text fields linked to subforms.

Hope this helps anyone with the same problem.
Justin