Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Combobox with LOV showing ID but would like to display more meaningful text

JamesGordonJul 4 2012 — edited Jul 5 2012
Hi, I'm experimenting with JDeveloper 11.2.
I have a base table/eo with an FK ID to another table/eo which is a lookup table.
On the base tables view I have created a combobox with LOV but it is showing the ID and I'd like it to show the name from the lookup table.
So rather than showing the ID 1 I'd like it to show James instead.
I can just about remember being able to do this in Oracle Designer.
I know this is something stupid but I've searched Google and not come up with anything.

CREATE TABLE ACCOUNTS
(
ACCOUNT_ID NUMBER NOT NULL,
ACCOUNT_LOGIN VARCHAR2(30 CHAR) NOT NULL,
FIRST_NAME VARCHAR2(50 CHAR) NOT NULL,
LAST_NAME VARCHAR2(50 CHAR) NOT NULL,
EMAIL VARCHAR2(150 CHAR),
CREATED_TIMESTAMP TIMESTAMP(6) WITH LOCAL TIME ZONE DEFAULT SYSTIMESTAMP NOT NULL
);

ALTER TABLE ACCOUNTS ADD (
CONSTRAINT ACCOUNTS_PK
PRIMARY KEY
(ACCOUNT_ID));

CREATE TABLE ACCOUNT_MODULE_ROLES
(
ACCOUNT_MODULE_ROLE_ID NUMBER NOT NULL,
ACCOUNT_ID NUMBER NOT NULL,
MODULE_ID NUMBER NOT NULL,
ACCOUNT_ROLE_ID NUMBER NOT NULL
)

ALTER TABLE ACCOUNT_MODULE_ROLES ADD (
CONSTRAINT ACCOUNT_ROLES_PK
PRIMARY KEY
(ACCOUNT_MODULE_ROLE_ID));

ALTER TABLE ACCOUNT_MODULE_ROLES ADD (
CONSTRAINT AMR_ACC_FK
FOREIGN KEY (ACCOUNT_ID)
REFERENCES ACCOUNTS (ACCOUNT_ID)
ON DELETE CASCADE
ENABLE VALIDATE);

I've created the LOV on AccountModuleRolesView.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 2 2012
Added on Jul 4 2012
12 comments
380 views