Creating correct relationship for report

5 pts.
Tags:
Access Tables
Mapping table relationships
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following