469,586 Members | 2,172 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,586 developers. It's quick & easy.

Master link to more than one child

Is this even possible. To be able to have a subform where the Master field
on the main form is linked to the subform via 1 child field OR another? So
the table for the main form, can be matched to 2 different fields (one or the
other). Can this be done with only 1 subform?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200510/1
Nov 13 '05 #1
2 3605

"Chewy1026 via AccessMonster.com" <u8613@uwe> wrote in message
news:5608441cb2ce4@uwe...
Is this even possible. To be able to have a subform where the Master
field
on the main form is linked to the subform via 1 child field OR another?
So
the table for the main form, can be matched to 2 different fields (one or
the
other). Can this be done with only 1 subform?


As far as I know, the link is limited to the specified Fields and only
those. There can be more than one Field... but not "alternative fields".

Depending on exactly what you are trying to accomplish, calculated fields in
the Query that is Record Source of the Form embedded in the Subform Control
_might_ be used to accomplish what you want.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #2
I agree with Larry. And with the same qualification that, depending on
exactly what you are trying to accomplish, it is possible to
programmatically change the Link Master Fields and Link Child Fields
properties. So, if you can find an event to suit your needs, this is
another potential possibility.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Chewy1026 via AccessMonster.com" <u8613@uwe> wrote in message
news:5608441cb2ce4@uwe...
Is this even possible. To be able to have a subform where the Master field
on the main form is linked to the subform via 1 child field OR another? So
the table for the main form, can be matched to 2 different fields (one or
the
other). Can this be done with only 1 subform?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200510/1
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Martijn Saly | last post: by
2 posts views Thread by gencode | last post: by
4 posts views Thread by MikaŽl PLOUHINEC | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.