Navigating through relationships

[Silex_BI]

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 A	Permission Set Ass 1	Permission Set 1	Field Permission 1
User A	Permission Set Ass 1	Permission Set 1	Field Permission 2
User A	Permission Set Ass 2	Permission Set 2	Field Permission 1
User A	Permission Set Ass 2	Permission Set 2	Field Permission 2
User B	Permission Set Ass 1	Permission Set 1	Field Permission 1
User B	Permission Set Ass 2	Permission Set 1	Field 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!

[v-jayw-msft]

Hi @Silex_BI ,

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

Best Regards,

Jay

[Silex_BI]

"Cannot determine the relationship between the fields" 

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

[AUDISU · Accepted solution]

@Hi @Silex_BI ,

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

Thanks.

[AUDISU]

Hi @Silex_BI ,

May I know the error message you et when add last column?

Thank you.