Solved

Oracle Application Express Tabular Form

Posted on 2009-05-18
5
1,156 Views
Last Modified: 2013-12-18
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
Comment
Question by:illtbagu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 4

Accepted Solution

by:
dkaisla earned 500 total points
ID: 24417837
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
 
LVL 4

Assisted Solution

by:dkaisla
dkaisla earned 500 total points
ID: 24417887
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
 
LVL 1

Author Comment

by:illtbagu
ID: 24435212
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
 
LVL 4

Expert Comment

by:dkaisla
ID: 24437314
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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question