Hi friends
I am a beginner in oracle forms and reports.
Please answer the following questions.

1)I am trying to generate eno automatically via seqence in emp table.While
giving a trigger
at block level pre_insert it is not working.Why?I had written the trigger as
select seqname.nextval into :emp.eno from dual;
But when I try the same trigger at new item instance(eno) it is working,but the
problem is
whenever I enter that eno item it is getting incremented and I am unable to
query the records.
2)Is it possible to select columns (items) from 2 tables in a single block.How?
3)Is it possible to update an item in the same block based on the value
entered to a different item.how?


Please help me.
thanks.