Re: HELP:SQLForms4.0 Cascading LOV

WALLY -- You would simply use the Show_LOV() built-in in a nested way

         as follows:

	      IF Show_Lov('FirstLOV') THEN
                /*
                ** You'll only get in here if the user
                ** Selected something (as opposed to cancel)
                */ 
		IF Show_Lov('SecondLOV') THEN
		  /*


		  ** You'll only get in here if the user


		  ** Selected something (as opposed to cancel)


		  */ 
		END IF;

	      END IF;

         And make sure that the WHERE clause in the SQL statement
         contains references to the appropriate columns on which you
         would like to restrict, and that the return items for the
         LOV's you're using properly return the LOV-selection's row
         values into the columns you desire.

         You can put this in a KEY-LISTVAL trigger, and mark the
         trigger to "Fire in Enter Query" mode, so that whether in
         normal or Enter Query mode, you logic will override.

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  Steve Muench              Email: smuench_at_oracle.com

--
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  Steve Muench              Email: smuench_at_oracle.com
  Forms Development
  Product Manager