I have a PeopleT and I created a GroupT. Then I created a PeopleXGroupT following the steps you outlined with three fields: ID, PeopleID and GroupID. Then the subform to show groups, which did not link automatically so I put in PeopleID and made it invisible. It still did not link so when a box opened, I put in PeopleID as Master and Child forms as well as GroupID on the second line. I slid the form into the PeopleF and when I selected a group, it entered the numbers on the junction table but the information does NOT show up on the Form. Is this enough information for you to tell me what I am likely doing wrong? Oh, I tried adding some data to the junction form and it "took" but not in the PeopleF.
Reply from Alex Hedley:
Have you create a combo box for both People and Groups on the JunctionF. Have you set a Default value for the People Combo so when it's on the PeopleF it defaults to the current person you're on? The Link Master/Child Fields should take care of the filtering.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 7.