Forum Discussion

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

Create a calculated columns from 2 tables

Dear Community, I have these 2 tables: Table1 Table2 The relationship between tables is many-to-many with column Client My objective is to have two calculated columns in Table1 where ...
marabeda's avatar
marabeda
Icon for Helper I rankHelper I
4 years ago

Hi technolog, it works! thank you. I solved first part of the question. The second part is how to show the value in table2[ore] in a column that match client in table1. Can you help? Can I write the same formula?

Many Thx

 

technolog's avatar
technolog
Icon for Super User rankSuper User
4 years ago

Yes, you can use the same formula - only replace Table2 to Table1 and all will work. 

Text me when it works.