Forum Discussion

sagarsahoo_123's avatar
sagarsahoo_123
Helper IV
3 years ago

Circular Dependency error while creating relationship between two table

Hi All, Please help me to resolve circular dependency error while creating relationship between two tables.   I want to rearrange the below given value in that particular order. But by defa...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

sagarsahoo_123 , If you have created that table from this table try to use distinct on top of it.

 

Example

Distinct(All(Table[Col]))

 

 

Also, in the table shown above you can mark Sorting as a sort column

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

  • sagarsahoo_123's avatar
    sagarsahoo_123
    Helper IV
    3 years ago

    Hello Amit,

    Actually I created a simple table manually by using Enter Data option given image below.

    Then tried to create relationship with main table.But not sure why i am facing circular dependancy error. Tried your given approach as well but it could not solve the problem.

    Any thing which i am missing here!Please suggest.

     

    Regards,

    Sagar