1 Reply Latest reply on Oct 6, 2016 4:25 AM by beverly

    Return a related value

    GJBDJC

      Hello all,

       

      I have a popover that contains 2 global fields.  I would like to type a unique identifier into one field (Project number) and have the second field automatically populate with the related value from another field (Product Name)?

        • 1. Re: Return a related value
          beverly

          I'm not sure of the use of the global for the second field, but there are a few ways:

           

          1. set up relationship, when the first global is changed, trigger a lookup to set the other field

           

          2. or trigger to ExecuteSQL()

           

          I would think the first is easier. And if the 2nd field is not a global, but the actual related field, it will populate automatically.