I have an 2 tables.

select emp_id,dept_name,emp_name,commision from employee_dets;

select emp_id,dept_name, bu,org from emp_profile;

I have an interactive grid based on EMP_PROFILE table.

Here:

EMP_ID  is a select list
select emp_name d,emp_id r from employee_Dets;

DEPT_NAME is also a select list: 

select dept_name d, dept_name r from employee_Dets where emp_id= :EMP_ID;

So DEPT_NAME is populating on basis of EMP_ID column. Currently its drop down.

But i want it to be read-only, still auto populate when EMP_ID is selected and save to database.

If i make it read-only-> Always, the value doesnt auto populate.