Forum Discussion

Matt22365's avatar
Matt22365
Resolver III
8 years ago
Solved

Relationship building error

Hi

 

I hope someone can help

 

I currently have a mixture of relationships between MS project tables which I have been using for a while now, however I am getting an error when I attempt a new relationship.

 

These are my current relationships

 

I now need to create a link between the task table and timeset table, however when I try I get the following error

 

Is it possible to keep my current links but also create a new relationship?

 

Thanks for your help

 

Matt

Need Help
  • Matt22365's avatar
    Matt22365
    8 years ago

    Hi

     

    Thanks for getting back to me

     

    That solution has worked, thank you. I also found another way to enable the task and timeset tables to relate. If you convert the directional arrows from single to both my issue sorted itself

     

    Thanks

     

    Matt

4 Replies

  • jthomson's avatar
    jthomson
    Solution Sage
    8 years ago

    You just need to make the new relationship inactive. If it's not letting you make it at all, temporarily make the existing relationship that's causing the problem inactive, then switch the active relationships around once the new one is in place

    • garvicasas's avatar
      garvicasas
      Helper I
      8 years ago

      Since there are two relations pointing to TimeSet, that would have a conflict between them. Just need to mark one inactive. Will work the same for you, but with solve the problem.

      • Matt22365's avatar
        Matt22365
        Resolver III
        8 years ago

        Hi

         

        Thanks for getting back to me.

         

        That has worked, however I found a different solution which also worked, I changed the filter direction from single to both which seemed to allow the task table to interact with the tmeset table.

         

        Thanks

         

        Matt