Suppose, I have two tables (Budget and Brandlist) in my model. These two tables share a common field Brand.
Values in the field Brand in the Budget table:
Values in the field Brand in the Brandlist table:
In case I create a listbox, I'd like to base it on the field Brand from the Budget table and to display only those brands which are available in the Budget table (A,B,C). I don't want the other brands to be displayed in my listbox.
How can I do it? It's not clear how I can refer to a field from a particular table while creating an expression in QV model.