Combine 2 table into another table

[TonyWang]

Hi there,

I have three tables, Table-1, Table-2, and Table-3. Can I combine Table-1[A] and Table-2[B] into Table-3[C]? At the same time, automatically combine Tabe-1[E] and Table-2[F] into Table-3[G].  Any changes in [A],[B],[E] and [F] should affect in [C] and [G]. 

Thank you all!

[WillowMobileSys]

You CAN create something to copy and update from one table to another.  BUT...a better to way to handle this is by using

References.between tables

A Reference is a column that holds a "pointer" to a row in some other table - could even be the same table.  From that Reference column you can access any column values from the row called "dereferencing".  If you setup your "dereference" values in a Virtual Column, they will automatically update anytime the value in the source row changes.

So in your example above - Table 3[C] would have a Ref column to Table 1[A] and another Ref column to Table 2[B].   etc...

Please refer to the article above for more details and then come back to the Community if you have any specific questions.

I hope this helps!

[TonyWang]

Thank you Willow. Is it possilbe to have Table-3[C]  to reference to both Table-1[A] and Table-2[B] at the same time?