Windows 7 64bit 
Access 2007
Hey there everyone! I have been creeping the forum and using the advanced search, however I haven't found the answers I seek.
I have a database that is made up of 10 tables. Using these 10 tables, I have created multiple forms that I will be using in our sharepoint as XML forms for our sales teams.
On the main contact form called "Contact Details", information is pulled from the "Contact" table and shown. There are also two working subforms, that show two different types of products that the contact might hold. For example, Bob might hold 3 or 4 different products of "X" and 2 of "Y". I have created click throughs that will allow you to drill down to the actual product information for that client. No problems here.
The one that is giving me issues is the "Group Product". A company (different table than the contact table) has a specific product (again, it could be 1 or 5 products they hold). On the "company info" form, I have the subform working to show what products the company holds. No problems with that.
However, in the Contact Details form, I cant get a subform working to display the groups to which this person is a member of. A company can have many groups, and a contact can be a member of many groups as well. What I need to do is be able to also tie multiple contacts to multiple groups (many to many relationship). For example, Bob might work for XYZ company, and be a part of the group product. I want to click on the "contact details" form and see a subform that shows the products, just as the other two are already working do. I want to also have form control to click through to that record.
Any pointers on to where I need to focus attention to?
Just writing the above, I have an idea of something I can try. I will be working on that idea while waiting for some suggestions to roll in. If I get what I'm after, I will update this posting!
Reply With Quote
