This content has been marked as final. Show 6 replies
Thank you for your reply!
I don't know for sure, but I'm doubtful. I need to be able to click on a record in the interactive report and open a subform containing only the selected record's data, for the purpose of editing columns in the selected record. The fields on the subform will be a combination of text and drop-down list boxes (called combo boxes in Access).
Here is what I need to do:
Say my subform only has 1 combo box, bound to a column in the report called "USERNAME". Say the LOV for the combo is derived from a table called USERS. If I selecting a record in the report where the USERNAME is "POWELL" will place "POWELL" in the combo box on the subform, once it is open.
Now, I want to change the USERNAME to "MARVIN", so I click on the combobox and select MARVIN from the USERS table. Then I save the record. Wen I go back to the report, I need to see that the record now contains a USERNAME of "MARVIN" in place of "POWELL".
This is really easy to do in Access for example, but I can't seem to find doc. on here that shows how to do the same thing in APEX.
This looks promising. I'll give it a try and let you know. Thank you very much for taking time to help!
I haven't tried the wizard yet, but I'm hopeful that it will walk me thru creating combo boxes linked to tables from which I can select values to update the master table record. I'm a little dubious that the wiz will be that smart, but one can hope.
I figured this out. I changed the form field from a text box to a select box,
entered a LOV definition like this:
select CONT_DEPT_NAME display_value, CONT_DEPT_ID return_value
order by 1
set the LOV Display Null setting to "Yes", Changed the Default Value Type setting to "PL/SQL Function Body", and entered a PL/SQL statement under default to return a single value from an table, like this:
v_value VARCHAR2(<your data max length>);