I have few list values, which are getting populated from a record group. I put this code in When-new-item-instance trigger(which populates).
Problem : When I run the form, then it shows a blank list having an initial value and blank value, and when I press the initial value which is 'All GL Class Codes' then it pops up the original list(which it should be).
I don't know why it is behaving like this. I have also shown it in the forms of screenshots (step-by-step).
Please help me out in this matter.
Thanks in advance,
Record Group Query:
select 'All GL Class Codes', 'All', 1
select distinct b.product_gl_class_desc, b.product_gl_class_cd, 2
from product_gl_class b
order by 3, 1