Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1163
  • Last Modified:

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
0
illtbagu
Asked:
illtbagu
  • 3
2 Solutions
 
dkaislaCommented:
create an LOV which displays the names and returns the IDs and edit your column to display a select list with the defined LOV.
0
 
dkaislaCommented:
Go to Report Attributes
Click on the edit icon beside the column which you wish to display the name (dept name / emp name)
Under Tabular Form Element section, Display As Select List
Under List of Values section, specify the named LOV or define your LOV in the List of Values definition box
0
 
illtbaguAuthor Commented:
Thanks for the response. This partially works. If I use a Popup LOV instead of a "Select List LOV" it displays the id in the field.

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.
0
 
dkaislaCommented:
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.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now