APEX

I have created an application based off of a table and so the 1st page is the actual report and the 2nd page is the data entry form. I have changed the form elements (like text box to select list) etc.

I need to have (2) text box fields populated based on the value from the 2nd select list box. I created a pl/sql page process that will check the value of the select list and assign values to the text boxes. This is triggered when a POPULATE button is pressed.

When I select a truck number in the select list - nothing happens and the original select list values get reset back to original. There is another button used in order to insert the data so that's why I figured I needed to add another button to trigger the population of the text boxes from a table. Here is my pl/sql page process used to populate:

BEGIN
SELECT dr1_name, dr2_name
INTO
:P2_DRIVER_1, :P2_DRIVER_2
FROM
active_drivers a
WHERE
:P2_DRIVER_CODE = a.code;
END;

It is set to fire on submit - before computations and validations.

Regards,

Jeff