Forum Discussion

Jcramb's avatar
Jcramb
Frequent Visitor
7 years ago

Relationships 3 Tables With Many link to 1 Table with One

I have 3 tables (P6 Actual, P6 Early, P6 Late) all with the Activity ID column which have duplicates (Many).  These tables are filtered by the tables above.  I want the 3 tables (P6 Actual, P6 Early, P6 Late) to have a relationship with table P6 Activity ID's & Codes which also has Activity ID column but does not have duplicates (One).  I want this table to be boiled down to a list of the activity ID's that are in the 3 tables (P6 Actual, P6 Early, P6 Late).  How would I achive this?

Need Help

1 Reply

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Jcramb ,

     If there are related IDs between three P6 tables and P6 Activity ID's & Codes table, you can create relationships. Is there any error message? Or is part of the relationships inactive?

    Can you post a dummy file or some sample data? That we will test it. 

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.