I keep having difficulty with the Many to Many Relationship subform. Maybe I am asking too much? We have ProjectsT with MANY (upt to 8) CompanyT who have MANY ContactPersonT but each has only 1 ProjectID. CompanyT also has a CompanyTypeT which I would like to display in the subform. I tried a query and got messed up. Should the junctionT have ProjectID, CompanyID, ContactPersonID and CompanyTypeID?
Adam Schwanz
@Reply 5 years ago
What is the difficulty you're having? Are you just getting no data or incorrect data? Are your master and child fields linked properly?
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.
