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

    Return a related value


      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

          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.