illtbagu
asked on
Oracle Application Express Tabular Form
I am trying to create a tabular form from the table called Master Table shown below. The Master Table has a foreign Key relationship to both Department and Employee tables. In my tabular form I do not want to show the Department_ID and Employee_ID but instead show the Department_Name and Employee_Name. If I do a join in my "Region Definition > Source" everything displays correctly when the form is ran but when I try and add a new row or update a record in the form I get errors. How can I show Department_Name and Employee_Name instead of their ID's in the tabular form?
***Master Table***
Department Employee
-------------------------- -----
1 500
1 501
***Department Table***
Department_ID Department_Name
-------------------------- -----
1 HR
2 Sales
***Employee Table***
Employee_ID Employee_Name
-------------------------- -----
500 Joe
501 Bill
***Master Table***
Department Employee
--------------------------
1 500
1 501
***Department Table***
Department_ID Department_Name
--------------------------
1 HR
2 Sales
***Employee Table***
Employee_ID Employee_Name
--------------------------
500 Joe
501 Bill
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
i don't know if you can do that with popup lov because it's essentially a text item which gets populated by the return value when you select a value from the popup lov.
ASKER
Example: If I set the employee LOV to use a Popup LOV the field on the form still shows the id but the POPUP LOV shows the employee's name. Where if I use a "Select List LOV" instead, the pull down list on the form shows employee's name.
I need to use a "Popup LOV" because my list is too long for a "Select List LOV" and I get errors.