OraFAQ Forum: Forms » Master Details in Non Query Mode

Home » Developer & Programmer » Forms » Master Details in Non Query Mode (Oracle Form Builder 10g)

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

Master Details in Non Query Mode [message #668154]

Fri, 09 February 2018 00:09

SP23
Messages: 3
Registered: February 2018

Junior Member

Hello All,

I am unable to populate detail form, if entering Master details.

e.g If I am entering PO Number in Master, related lines should get populated.

If I am querying PO number field, I can see the Line details.But In non query mode

Please do let me know How can I achieve this

Report message to a moderator

Re: Master Details in Non Query Mode [message #668155 is a reply to message #668154]

Fri, 09 February 2018 01:50

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm not sure that
a) I understand what you are saying
b) You understand how Forms work

If you used Data block wizard (and yes, you should have) to create master-detail relationship, Forms would create all necessary triggers and procedures to make that relationship work.

When you run a form and enter query mode, then - by querying master block - detail block will automatically be populated (if detail data exists).

If you are in insert mode, then entering values in master block won't do anything "automatically" - you have to navigate to detail block and enter detail data.

Report message to a moderator

Re: Master Details in Non Query Mode [message #668158 is a reply to message #668155]

Fri, 09 February 2018 04:30

SP23
Messages: 3
Registered: February 2018

Junior Member

Thanks for Replay..

Below is my detail requirement.

Form has two section header and details.In header i am selecting PO Number from LOV.

Once I Select PO Number from LOV, corresponding PO lines should be populated in detail form.

Hope this is more clear.

Report message to a moderator