Choosing fields from Tables for concatenation
Hello.Is there a way to have a third table made of fields I select from two or more tables? In my case, I have two tables with several fields on each one. I want to be able to choose any field(s) from those tables so they show in a concatenated field on a third table. Sometimes I choose five fields from one table and three fields from the other one, sometimes I choose other differently. I was think to do that in a script but can't get my mind to engage on how to do it. Thank you.