I am creating a report that states a taskcard # plus the panels and zones that need to be inspected under that number. All are originated by an MPD #. I have 3 tables - a taskcard/MPD #; access panels/MPD #; zones/MPD#. My intention is that the MPD# gathers the taskcard # associated with it, plus the specific access panels and the specific zones. When I run a report just for one feature, a taskcard # or zone or access panel, it lists perfectly. When I ask for all three, the access panels associate with the zones. So instead of having a list of zones and a list of access panels, I have the list of access panels repeating for every zone: example: access panels 1,2,3 - zones a, b, c (this is what I want). I get 1a, 1b, 1c, 2a, 2b, 2c, 3a, 3b, 3c. I don't want them associated together. I want them listed independently under the MPD#. How do I alter the relationship between the tables to fix this problem? Right now, the Access, Taskcard, and Zone table are connected through the junction MPD # table.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!