Forum Discussion

Mackie's avatar
Mackie
Icon for Helper I rankHelper I
6 years ago
Solved

"Already exists" error when creating relationship

There is a problem. I can't create a relationship between 2 tables.

 

https://sharpsynappx-my.sharepoint.com/:u:/g/personal/mackie_sharpsynappx_onmicrosoft_com/EecGop0d1jBIr_H1YzWERu0Breol1XbuYB9cv4WMd7ZqUw?e=qV3UuJ

 

Could you download the file above and try to create a relationship between 'Top10 Products of Sales 3-months' and 'Sales' by a column 'ProductKey'? That causes an error saying "Already exists". But I can not understand what causes that error. How can I solve? Thank you.

 

 

 

Need Help
Tutorial Requests
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    @Mackie ,

    Hey try renaming the "ProductKey" field in the top 10 products table and then join them.

    He's working alongside me.

    Capture.PNG

    Don't forget to thumbs up 👍 and accept this as a solution if it helped you.

3 Replies

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    @Mackie ,

    Hey try renaming the "ProductKey" field in the top 10 products table and then join them.

    He's working alongside me.

    Capture.PNG

    Don't forget to thumbs up 👍 and accept this as a solution if it helped you.