APEX

Hi, all,

Our Apex is 24.2.13, I want 2 classic reports to act like master-detail, kind of. Pls see screen shot.

If I use LINK on column “PO#”, it kind of works but it involves a page submit, more importantly, the master report pagination is lost after LINK click. I am thinking of using action like <a href="#action$log-detail?id=#INV## >#PO## </a> for PO# column , I tried select data like this then use RICH-TEXT with HTML format, or LINK with URL syntax like above…neither works. Any suggestions? Thank you

*action is created like here

apex.jQuery(window).on('theme42ready', () => {
  apex.actions.add([
    {
      name: 'log-detail',
      Label: 'API Log Detail',
      action: (event, element, args) => {
        apex.items("P10_INV").setValue (args.id); 
        // P10_INV is hidden page item, then I use Change DA to post a session state and run apex.region.refresh()
        // detail is like "select from log_detail where INV#=:P10_INV"
        return true;
      },
    },
  ]);
});