I am working on forms 6i Oracle 8i,
under WIN-NT 4.0 Workstation.

Please let me know immediately.

My propblem is:

I am not displaying more than one record
in multirecord block from a database table.by writing a select statement in form.

Example:,,

In form, I have a multirecord block
(block name is DEPT and also basetable
name is DEPT). I want to fetch the records
from DEPTNEW table into that multirecord block.

If only one record in DEPTNEW table, then it is worked properly.
But the problem is, if in DEPTNEW table has more than one record
then the records are not displayed in that DEPT block on forms.

(NOTE: DEPT and DEPTNEW both tables have same structure)

Please give me the solution as soon as possible,

thanks a lot for ur cooperation.

my email id is sri_garige@hotmail.com

thank u.