Skip to Main Content

APEX

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

cascading select lists in tabular form

853243Mar 8 2012 — edited Mar 9 2012
APEX - 4.1.0.00.32
DB version - 10g
Web server architecture - OHS
Browser - IE8
Theme - 9

Hello

I have a tabular form with two select lists, I would like to select a value from the first list that will help determine what shows up in the second list. The column name of the first select list is "DL_DETAIL_PROJECT_ID", so I would like to be able to have a quey for the second select list that looks like

select desc d, id r
from <table>
where <another id on the table> = DL_DETAIL_PROJECT_ID

but I am not sure how to get the value from DL_DETAIL_PROJECT_ID?

Also the list of values seciton on a regular from shows an option for cascading lists, but the tabular form, list of values section does not, is it possible to have cascading lists within a record on a tabular form?

Thank you in advance for any assistance.
This post has been answered by Roel Hartman on Mar 9 2012
Jump to Answer

Comments

Roel Hartman
Answer
Yes you can. See the links provided:

http://apex.oracle.com/pls/apex/f?p=39514:1:
http://www.inside-oracle-apex.com/generic-solution-for-cascading-select-listslovs/
http://dbswh.webhop.net/dbswh/f?p=BLOG:READ:0::::ARTICLE:2003800346210117
Marked as Answer by 853243 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 6 2012
Added on Mar 8 2012
1 comment
13,010 views