there are two tables emp and file_ref.
a text item manually add and pop list.
i want when i select a from poplist. text item show the a column of file_ref table.
and when i select b from poplist it show b column from file_ref.
i use trigger
and query is
if :emp.fileno = 11 and :emp.pop_list= 'A' Then
select A into :file_ref.filename
where empcode = '10';
end if ;
the problem i am facing is that.
when i execute query system show no data.
please help me. and tell me what kind of settings are required in items property for this task.
i will wait for your replies.