Home » Developer & Programmer » Forms » Drop Down Lists.
Drop Down Lists. [message #210962] Sun, 24 December 2006 06:13 Go to next message
jewelthief
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.

Report message to a moderator

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
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member
search for add_list_element. F1 has it

Report message to a moderator

Re: Drop Down Lists. [message #212191 is a reply to message #210962] Thu, 04 January 2007 04:09 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

David

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 15:32:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.