Hello All,
i am new to oracle apex and i have requirement to create a manual tabular form. i've created it using collections, I've loaded the collection when the page loads. elements in form are displayed as select list. inserting and updating works good. the only problem i have is when i select the value in selected list and update, the value is updating in database correctly but the same value is not displaying for that record in select list. for ex;
( first three elements are selected list, descr is a text field)
empno empname dept descr
1 John 10 abc
1 John 10 xyz
where as in data base the values are
1 john 10 abc
2 mary 20 xyz