I am working on an inventory app. One of my primary views is to add stock to inventory. The way I have it set up now is when someone enters the product number on the primary view, the product name and the product size appear below the product number. I did this by creating 2 virtual columns with SELECT formulas to pull the data.
My question is is this the best way to do it as far as speed is concerned? Would it be better to have a separate view triggered once the product number is entered, and on that separate view one could see the product name, size, etc. and the user could input the quantity on that view.