Under Oracle APEX 24.2.11, I have a form p. 24 with an item “P24_BENEVOLE” type LOV, the LOV of this item is :
select a.id as r,
a.nom || ' ' || a.prénom || ' - ' || a.id || ' - ' || b.FIABILITE as D
from ad_benevole a
left join ad_notation b
on a.id = b.benevole
where a.membre_actif = 'Oui'
order by a.nom
You see the “Participation is ”Très forte" (which is "FIABILITE" column in the table AD_NOTATION).
There is a button “Modifier la Participation" on this form. It opens a modal p.37. When I change the value of the item P37_FIABILITE, and apply modification on it, it comes back to page 24.
But the value ”Participation" of the Item P24_BENEVOLE is not changed (still “Participation très forte). I tried to regenerate this element after modifying the ”Participation" on closing the modal page 37, withous success.
How to update P24_BENEVOLE ?
Best regards.