0 Replies Latest reply: Nov 22, 2013 8:20 AM by 7a934c2e-f20c-4f30-a56a-1df65a93b50a RSS

    Set Form Values From Interactive Report Row

    7a934c2e-f20c-4f30-a56a-1df65a93b50a

      Using Apex 4.2.

       

      I have two tables: T1 and T2

       

      Table T1 contains five columns: CT11, CT12, CT13, CT14, CT15

       

      Table T2 contains 4 columns: CT21, CT22, CT23, CT24

       

      I have a page with two regions. Region 1 is a Form on a Table using table T1. Region 2 is an Interactive Report ( IR ) on table T2.

       

      The SQL for region 2 is:   select apex_item.RADIOGROUP(p_idx => 1, p_value => CT21) "Choose", CT22, CT23, CT24 from T2;

       

      When the user clicks a radio button for a row in the Interactive Report, I would like the values in the IR cells CT22, CT23, CT24 to populate the CT13, CT14, CT15 fields in the table form in region 1. If a user clicks another row radio button, the values should update.

       

      Any help is greatly appreciated.  Thanks!