This is an Interactive Grid called Visit Duration:
and its source is the following SQL query:
Select ROWID,
CODE,
(Select odm.First_Name || ' ' || odm.Last_Name from OPC_DOCTORS_MACHINES odm
where odm.CODE = ovd.CODE) as DESCRIPTION,
V_CODE,
VISIT_DURATION,
PAIEMENT,
D_DISCOUNT,
DISCOUNT
from OPC_VISIT_DURATION ovd
As you can see the IG uses the OPC_VISIT_DURATION table as the main source except for the DESCRIPTION column that uses OPC_DOCTORS_MACHINES as its source. In OPC_VISIT_DURATION, CODE is a foreign key to the table OPC_DOCTORS_MACHINES. So, in the Interactive Grid whenever the user selects a value for the Code column then the cell for the Description column on the same row should get updated with the equivalent value. The problem is I can’t find any way to update the Description column. I’ve tried all types of Dynamic Actions and none of them work.