OraFAQ Forum: Forms » Master Detail

Home » Developer & Programmer » Forms » Master Detail (Developer 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Master Detail [message #405102]

Tue, 26 May 2009 06:20

jramya
Messages: 42
Registered: April 2008

Member

Hi,
I have used serial numbers to simplifyy my query.

I am having 4 blocks in my form block1,block2,block3,block4.

This form is used to just insert records into the db.

block1 - Control Block
block2 to load dynamic headers - Multi Record Block
block3 to insert into table3 - Multi Record Block
block4 to insert into table4 - Multi Record Block

As the user selects a service from a control block,
block 2 loads the dynamic headers
block 3,4 user enters data to save

All I have to do is relate block 2 to block 3 by rowlevel.
i.e block2.id(rowid)=block3.block2id(rowid)

I cannot relate using relationship as in block2 i execute query and block3 i use to insert.
I tried block 2 post_query to create record in block3 -Dint work

Please can someone suggest me the other possibilities?

Report message to a moderator