I have successfully created a master-detail form in Oracle Forms 6i. The master form functions as expected, and the detail section is a tabular grid that runs smoothly, similar to the department and employees form. However, when I change the department, it automatically shows all the employee records related to that department, which is great. The issue arises in the detail section, where I have used the when-validate-item trigger to display the employee’s salary in a non-database item within the grid. Unfortunately, it does not show their salary in the text salary field. The form runs correctly otherwise. I would appreciate any ideas on how to display the employee’s salary and other information using the when-validate-item trigger. Thank you.

select salary into :empoyee.textsalry form salary where emp_id=:employee.emp_id;
but it how show the salary in :empoyee.textsalry

waiting for you valuable reply

select salary into :empoyee.textsalry form salary where emp_id=:employee.emp_id;