Solved

Oracle Application Express Tabular Form

Posted on 2009-05-18
5
1,135 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
Read about achieving the basic levels of HRIS security in the workplace.
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 setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

763 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

6 Experts available now in Live!

Get 1:1 Help Now