2 Replies Latest reply: Mar 16, 2015 6:56 PM by Massimo Grossi RSS

    How can I refer to a field of a certain table

    Larisa Filonova

      Hi,

      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:

      A

      B

      C

       

      Values in the field Brand in the Brandlist table:

      A

      B

      C

      D

      E

      F

      G

       

      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.

       

      Thank you in advance.

       

      Larisa Filonova