Solved

Oracle Application Express Tabular Form

Posted on 2009-05-18
5
1,145 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
crm 2010 on premise 5 62
Bash Script to Analyze Oracle Schemas 11 83
passing parameters to sql script oracle 4 26
SQL Developer 6 27
Note: You must have administrative privileges in order to configure lead or case queues. Salesforce.com (http://www.Salesforce.com) is a cloud-based customer relationship management (CRM) system. It is widely used around the world by sales and ma…
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.
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 Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

910 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now