Link Master/Child fields for a subform data source with multiple parameters?

[John Vinson]

On Mon, 21 Jul 2003 19:36:18 -0700, "Tim Cali" <cali_876@yahoo.com>
wrote:

>Can somebody explain why I would use LinkMasterFields and LinkChildFields
>for a subform?

Ordinarily one would do so to maintain relational integrity between a
"one" side table on the mainform and a "many" side table on a subform.
The link fields not only ensure that only linked records are displayed
on the subform; it automatically fills in the "one" side linking value
into the Foreign Key field in the subform's recordsource.

>I have a form and a subform. To view data in the subform, I select 3 values
>from 3 comboboxes on the main form, and then use those 3 values as the
>parameters for the query, which is the subform's data source.

View only? or edit? What about creating new subform records? Is the
mainform bound or unbound?

>So far, I have been requerying the subform data source during the
>AfterUpdate event for each of the 3 comboboxes, which has worked as
>expected. I see that I can also set these Master/Child links but I don't see
>how this could help me.
>
>Can I set these Master/Child links in my case? Is there a difference? Any
>further explanation is appreciated.

If it's working, go for it. You might want to try it both ways to see
if there's any performance difference; I wouldn't really expect there
to be but I really don't know!

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]

[John Vinson]

On Mon, 21 Jul 2003 21:26:57 -0700, "Tim Cali" <cali_876@yahoo.com>
wrote:

>Now that I've detached the mainforms binding
>(which wasn't needed apparently), I can see that Access won't even let me
>try to link Master/Child fields.

Oddly enough, the combo box wizard and the dropdown list for entering
Master Link Fields don't permit it, but you can in fact *type in* the
names of the three combo boxes in the Master Link Field property.
Putting the corresponding fields from the subform's recordsource will
provide the link functionality.

Thanks for the kind words!

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]

[Tim Cali]

Wow...cool. Thanks.

"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:qkiqhvssr0bincm60um6pad6u8npravnu5@4ax.com...

> Oddly enough, the combo box wizard and the dropdown list for entering
> Master Link Fields don't permit it, but you can in fact *type in* the
> names of the three combo boxes in the Master Link Field property.
> Putting the corresponding fields from the subform's recordsource will
> provide the link functionality.