Populating a different drop down list for each record in a block
I have a multi-record block that is populated from the database. On the POST-QUERY trigger, I am trying to populate a drop down list in each row, with each drop down list having different values for each record returned.
The block is based on a table called CALL_OBJ and the drop down lists are to be populated from another table called CALL_OBJ_REASONS. They are joined on a unique number call CALL_OBJ_NBR. Each CALL_OBJ record could have 1 or more associated rows in CALL_OBJ_REASONS.
In the CALL_OBJECTIVES block I have a non-database List item called REASON and in the POST-QUERY trigger on the block I am performing the following: