We have ITEMS table with columns as type,id(PK),id_number, name,desc,deprecate . We need to create a form
using this table as follows.
1. Need to provide dropdown option to select 'type'
2. Based on 'type' selection,'id' field dropdown will be populated.(Corresponding IDs of selected type)
3. Based on Id selection, need to fill the rest of form fields as read only.
At the end, user can submit the form. Based on user selection, depricate column value should be updated for that particular row.
So far, I was able to create dropdown using LOV.
How to populate the Dropdown of ID based type selection?
How to populate the rest of form fields as Readonly based on Id selection?
It would be great, if you can suggest any pointer having similar usecase.
Thanks,
MSR.