Forum Discussion

CG20's avatar
CG20
Regular Visitor
2 years ago

Need help in calculated column

Hi All, I'm struggling with the calculations below is the data i.e. is Table1 & Table2, they have Many(Table1) to One(Table2) relationship.     I want that if ID & Country from Table1 has...
Need Help
Tips and Tricks
Arul's avatar
Arul
Super User
2 years ago

CG20 ,

Which column serves as the relationship key between the tables? Neither the "country" column nor the "ID" column appears to satisfy a one-to-many relationship between the tables.

CG20's avatar
CG20
Regular Visitor
2 years ago

Hi Arul,

 

I had created a calculated column which contains concatenation of id&country in both the tables. When you create that you will see a Many(Table1) to One(Table2) relationship.

 

If you still have any doubts do reply on this post.

 

Thanks & Regards

CG20