Oracle Forms Dynamic LOV
<p>I'm working with 2 LOV's for my form. One is a regular LOV and the other is a dynamic LOV. Cannot figure out how to clear the dependent LOV.</p>

<p>for example my first LOV I have:</p>

<pre><code>select job_id, job_name from jobs
</code></pre>

<p>and my second LOV is:</p>

<pre><code>select employee_id, employee_name from employees where job_id = :job_block.job_id
</code></pre>

<p>I select the job_id and job_name from the first LOV and then I choose the corresponding employee_id and employee_name from the second LOV.</p>

<p>Now if I go back and pick a new Job_id from the first LOV, is there a way I can clear out the employee selection automatically from the first time around?</p>

<p>Any help would be appreciated. Thanks.</p>