I'm creating a database in MS Access that has 3 many-to-many table relationships in it. The database is for organizational projects - each project can have many partners involved and can meet the intent of multiple policies, and every combination of this relationship. I was thinking of creating a large junction table to handle all the possible combinations, but was then thinking about how queries would be shown in reports. I think the junction table would look like this:
Now, if I wanted to create a report that was meant to query out a particular project and show all of the policies it relates to and the partners involved, is there a way I can avoid the duplication shown in the following example, and just have 'Marketing review' shown once, with each related policy and partner shown once?:
This is the underlying report query:
Thanks,
Jason
-jjmclell
Now, if I wanted to create a report that was meant to query out a particular project and show all of the policies it relates to and the partners involved, is there a way I can avoid the duplication shown in the following example, and just have 'Marketing review' shown once, with each related policy and partner shown once?:
This is the underlying report query:
Thanks,
Jason
-jjmclell