 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 2005Master to more than 1 child field
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? No. > 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? > 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 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?  SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) 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!! >> 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 [quoted text clipped - 5 lines] >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 [quoted text clipped - 6 lines] > 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!! I see, and that makes sense. You'll have to requery the subform in the Current event of the main form. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.