Forum Discussion

Silex_BI's avatar
Silex_BI
Frequent Visitor
4 years ago
Solved

Navigating through relationships

Hi community!

 

I have a fairly basic question I can't wrap my head around.

 

Here's my object model:

 

If I try to put in a table User ID, Permission Set Assignment ID, Permission Set ID and Field Permissions ID, I get a relationship error.

I would have assumed that I would have had a table with User IDs, their related Permission Set Assignments (therefore, User lines would be demultiplied), each Permission Set Assignments' related Permission Set, and for each Permission Set, all of its related Field Permissions. Something like:

 

User APermission Set Ass 1Permission Set 1Field Permission 1
User APermission Set Ass 1 Permission Set 1Field Permission 2
User APermission Set Ass 2Permission Set 2Field Permission 1
User APermission Set Ass 2Permission Set 2Field Permission 2
User BPermission Set Ass 1Permission Set 1Field Permission 1
User BPermission Set Ass 2Permission Set 1Field Permission 1

 

If I have the first three columns (to the left) it works, but as soon as I add the last column, which should demultiply lines, it gives me a relationship error.

 

Any clue what I am not understanding here?

This conceptual question is bugging my mind as it seems trivial but I can't seem to figure out the logic of it.

Thanks a lot!

  • AUDISU's avatar
    AUDISU
    4 years ago

    @Hi Silex_BI ,

    Change the following highlited relationship  to otherside (Highlited arrow should be in to other side).

     

    Thanks.

4 Replies

  • Silex_BI's avatar
    Silex_BI
    Frequent Visitor

    "Cannot determine the relationship between the fields" 

    Also I have tried making the relationships bidirectionnal but it still did not work

    • AUDISU's avatar
      AUDISU
      Resolver III

      @Hi Silex_BI ,

      Change the following highlited relationship  to otherside (Highlited arrow should be in to other side).

       

      Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Silex_BI ,

     

    Does the above method work? If it works please mark it as solution.

     

    Best Regards,

    Jay