Refernce a virutal Concatenate column

[Jimmy_Ruptash]

Hello,

I have two Data tables,

TABLE 1 : CUSTOMERS
TABLE 2 : INVENTORY

In Table 1, I have all the information of the customer, and instead of typing manually the car he is interested in, I want to be able to choose it from the INVENTORY column.

So I created a ''Vehicle_of_interest" virtual column into INVENTORY, identified as my label, and CONCATENATE([stock], " ",[make], " ",[model], " ",[year]), so it could show into one single line to make it cleaner.

Then, In the Customer data, I created a “STOCK” column that I referenced to the INVENTORY column.

All seems to work, however, I was wondering if that was the way to go, or there’s another way that to do it so that if I add new functions, it won’t interfere.