Dear all, i am using apex 5.1.3 on windows and oracle database 12c.
it seems like i am stuck in a very basic problem.
i have created an Interactive Grid on a table named EVENTS_TASKS. I want to add a dislplay column named EVENT_NAME to this IG, i want to populated this EVENT_NAME column from EVENTS tables.
EVENT_TASKS has EVENT_ID column which is foreign key references to EVENTS table.
i have created a column in the IG and name it EVENT_NAME. now how can i set its value when the IG report is run?
please note that this IG is only for update purpose. the end user will not add a new row to it. please not in the picture that the column label is not showing for the column which i manually add it. although i have set its alternative label (look the second image).
can somebody guide me how to set the event name colum.?
thank you.