Oracle Forms (MOSC)

MOSC Banner

Populating a different drop down list for each record in a block

edited Nov 24, 2011 7:45PM in Oracle Forms (MOSC) 1 commentAnswered
Hi everyone,

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center