Hi Dears,
I am facing an issue with an Interactive Grid in Oracle APEX 24.1, which is populated with data from a base table containing employee related information. I have added a display-only column (EMP_NAME) to the grid, but I need to retrieve and display the employee name from the Employee Master Table based on the IDNO column in the grid.
In Oracle Forms, we could easily handle this using a Post-Query Trigger with a simple PL/SQL block. However, I am unsure how to achieve the same functionality in Oracle APEX as I am very new to this platform. I have tried multiple approaches, but none have worked so far.
Could you please guide me on the best way to achieve this in APEX? Your help would be highly valuable and greatly appreciated.
Thank you in advance for your support!
Best Regards,
AR Kappil