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.