title: Filter Data block with a LOV value in Oracle Forms 10g
body: <p>I need to implement a simple product form from a block of data called "<strong>PRODUCTS</strong>".</p>
  
  <p>The products are related to a "Partner" through the field "<strong>COMPANIES_PARTNERS_ID</strong>".</p>
  
  <p>This field will be represented by an <strong>LOV</strong> to select the Partner for which we want to visualize your products.</p>
  
  <p>If there is not a partner currently selected, all your products should be displayed. And when a partner is selected, only their products should be displayed.</p>
  
  <p><strong>The form will look like this:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/OD7f5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OD7f5.png" alt="oracle forms"></a></p>
  
  <p>The button to the right of the search field should show the LOV and launch the query. I tried the following code as a <strong>"Smart Trigger"</strong> when I pressed the button. But it does not work well at all. The LOV list appears twice and when no partner is selected, no product appears.</p>
  
  <p><a href="https://i.stack.imgur.com/F8Jbq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/F8Jbq.png" alt="enter image description here"></a></p>
  
  <p>Could someone help me to implement this functionality? Thank you</p>