Forum Discussion

milkynight's avatar
milkynight
Icon for Helper I rankHelper I
4 years ago
Solved

Troubleshooting table relationship issue

Hey guys,   Appreciate your help to solve the problem about the table relationship. In detail, I have 2 tables - A and B - that share a common column named "Store". I link them up by Many to One (M...
Need Help
  • milkynight's avatar
    milkynight
    4 years ago

    Hi v-chenwuz-msft 

     

    I reloaded the excel file and rebuilt the relationship. This time it works and problem is solved, Im not sure why. Thank you anyway!

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi milkynight ,

 

I guess the new store name of Table B is not the same as Table A, please check if there some space at the end of the string.

 

I recommend you to create the one side via VALUES().

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.