?
Solved

Oracle Application Express Tabular Form

Posted on 2009-05-18
5
Medium Priority
?
1,159 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 2000 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 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
This video shows how to recover a database from a user managed backup
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

777 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