title: Oracle APEX how do I populate cascading select lists without page submit
body: <p>I have an APEX page with a few select lists, using collections to save and refresh the page.  The "System" select list is dependent upon the "Brand" selected value.  I have the page working how I want, but it requires the page to be submitted after a "Brand" value is chosen so that the "System" lov is properly populated.</p>
  
  <p>I am trying to make it so that when the "Brand" value is changed or selected, the "System" lov is changed immediately without needing a page submit.  I've been reading and it seems you need to use jQuery and AJAX callback, but I just cannot get my head around that and make any progress.</p>
  
  <p>Hoping someone can help me.  I am certainly a rookie with web coding in general.</p>
  
  <p>Added: my local APEX version is 5.0.3.</p>
  
  <p><a href="https://apex.oracle.com/pls/apex/f?p=4550" rel="nofollow noreferrer">https://apex.oracle.com/pls/apex/f?p=4550</a></p>
  
  <pre><code>Workspace: UNCLE_BUCK_WS 
  User: developer1 
  Pwd: developer1 
  Application 83513 - Tooth Selector 
  Page 5: Page that works using submit page 
  Page 6: Page I started trying to use jQuery, but did not get very far
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/Z2qJ7.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Z2qJ7.jpg" alt="enter image description here"></a></p>
  
  <p>Added:
  There is no cascading LOV for manual tabular form.  See my region definition below.  Hoping someone can still help, maybe copy my page and make the required changes.</p>
  
  <pre><code>select apex_item.select_list_from_query(p_idx =&gt; 1,  
                                          p_value =&gt; n001,
                                          p_query =&gt; 'SELECT tooth_number display_value, tooth_number return_value FROM psp_teeth WHERE tooth_numbering_method = :P5_TOOTH_NUMBER_METHOD
                                                      ORDER BY tooth_number',
                                          p_null_text =&gt; '- Choose Tooth -')
         || apex_item.hidden(p_idx =&gt; 50, p_value =&gt; seq_id) Tooth_Number  
  , apex_item.select_list_from_lov(p_idx =&gt; 10, p_value =&gt; c001, p_lov =&gt; 'BRAND', p_null_text =&gt; '- Choose Brand -') brand  
  , apex_item.select_list_from_lov(p_idx =&gt; 12, p_value =&gt; c002, p_lov =&gt; 'TYPE', p_null_text =&gt; '- Choose Type -') type  
  , apex_item.select_list (p_idx =&gt; 14,  
                           p_value =&gt; c003,
                           p_list_values =&gt; CASE c001
                                            WHEN 'BRAND_A' THEN 'SYSTEM_A1,SYSTEM_A2'
                                            WHEN 'BRAND_B' THEN 'SYSTEM_B1,SYSTEM_B2'
                                            END,
                           p_show_null =&gt; 'YES',                         
                           p_null_text =&gt; '- Choose System -') system  
  , apex_item.checkbox2(p_idx =&gt; 16, p_value =&gt; seq_id, p_checked_values =&gt; CASE c004 WHEN '1' THEN seq_id END) delete_row
  from apex_collections  
  where collection_name = 'TEMPCOL'
  </code></pre>