Can I use a virtual column (a concatenation of 2 fields previously inputted) as a reference to a different table so that I can populate other data?
Hi @Ivie_Gonzales, Based on my understanding and testing , ,technically yes, you can do that.
i believe it is equivalent of a computed key. I am sure you have already considered that concatenation should create a key that
uniquely identifies the row of source table from where you will pull the data.
Yes, you can choose virtual column as a key column as well.