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)?
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.
Retrieving data ...