Combobox with LOV showing ID but would like to display more meaningful text
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.