Home » Developer & Programmer » Forms » Drop Down Lists.
Drop Down Lists. [message #210962] Sun, 24 December 2006 06:13 Go to next message
Messages: 2
Registered: December 2006
Junior Member
I am new in form developer.I have two drop down lists on my canvas
and i have two tables in databases named books and chapters(Chapters have foreign key i.e. book_id from books table).
I have populated one drop down list with book names from books table.what i want to do is, when user select certain book,its corresponding chapters from chapter's table should populated in the other drop down list that is on my canvas.

I know that i have to use when-list-changed trigger but what after that?
any help would be appriciated.
Re: Drop Down Lists. [message #211351 is a reply to message #210962] Thu, 28 December 2006 03:02 Go to previous messageGo to next message
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

search for add_list_element. F1 has it
Re: Drop Down Lists. [message #212191 is a reply to message #210962] Thu, 04 January 2007 04:09 Go to previous message
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
In the second LOV reference the item (:blk.books) in the where cluase of the Recor_Group used by the LOV so that only that book's chapters are retrieved.

Also have a look at http://www.orafaq.com/forum/m/167024/67467/?srch=master+detail+LOV#msg_167024

Previous Topic: How libraries work in Forms
Next Topic: ORA-00997 : illegal use of LONG datatype
Goto Forum:

Current Time: Wed Oct 26 05:13:55 CDT 2016

Total time taken to generate the page: 0.11485 seconds