Master to more than 1 child field

  • Thread starter Thread starter Chewy1026 via AccessMonster.com
  • Start date Start date
C

Chewy1026 via AccessMonster.com

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?
 
Chewy1026 via AccessMonster.com said:
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?
Click to expand...

As Klatuu says, no. But I'm curious about the circumstances that would
make you ask this question. Would you be interested in describing your
setup and what you would hope to achieve with such an arrangement?
 
Well, I have a main table with a name field and in the sub table, the name
can be found in to fields. In my case, the name can show up in a field
called sender and in a field called recipient. I want to see all the stuff
for this dude that he received or sent on the subform.

Now, there is actually a solution to this. Make a subform but do not use any
master/child links but instead, base the subform off a query that references
the name on the main form. The query would pull all records where the sent
field equals the name on the main form OR where the recipient field equals
the name on the main form. Viola!!
 
Chewy1026 via AccessMonster.com said:
Well, I have a main table with a name field and in the sub table, the
name can be found in to fields. In my case, the name can show up in
a field called sender and in a field called recipient. I want to see
all the stuff for this dude that he received or sent on the subform.

Now, there is actually a solution to this. Make a subform but do not
use any master/child links but instead, base the subform off a query
that references the name on the main form. The query would pull all
records where the sent field equals the name on the main form OR
where the recipient field equals the name on the main form. Viola!!
Click to expand...

I see, and that makes sense. You'll have to requery the subform in the
Current event of the main form.
 
Back
Top