Home » Developer & Programmer » Forms » Master/Detail/Detail block (Forms 6i)
Master/Detail/Detail block [message #389270] Fri, 27 February 2009 23:54 Go to next message
sadiq106
Messages: 22
Registered: February 2009
Junior Member
I have created three tables as under

CREATE TABLE FINAL_INSPECTION_M
(
ID VARCHAR2(5),
REPORT_NO VARCHAR2(10),
INSPECTION_DATE DATE,
UNIT_NO VARCHAR2(10),
SUPERVISOR_CODE VARCHAR2(10),
)

CREATE TABLE FINAL_INSPECTION_MD
(
ID VARCHAR2(5),
BATCH# NUMBER(20),
B_PCS NUMBER(5)
)

CREATE TABLE FINAL_INSPECTION_D
(
ID VARCHAR2(5),
BATCH# NUMBER(20),
FAULT_NAME VARCHAR2(25),
FAULT_QUANTITY NUMBER(5),
W_CODE VARCHAR2(10),
CLIPPER_CODE VARCHAR2(10)
)

A unit supervisor have to work on many batches and a batch may have many faults.

can any body guide me or make a sample form of master/detail/detail block.

thanks in advance
sadiq
Re: Master/Detail/Detail block [message #389301 is a reply to message #389270] Sat, 28 February 2009 05:14 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use Data Block Wizard to create all three blocks; the second one will be detail of the first one, while the third block will be detail block of the second one. Wizard will create all triggers, procedures and settings necessary for master-detail relationship work properly.
Re: Master/Detail/Detail block [message #389312 is a reply to message #389301] Sat, 28 February 2009 06:12 Go to previous messageGo to next message
sadiq106
Messages: 22
Registered: February 2009
Junior Member
I'm facing problem when I entered more than one batch# in second block and against each batch# more than one faults in third block then it replace all batch# in third block with last batch# in second block.

can u please make a sample form for this.

sadiq
Re: Master/Detail/Detail block [message #389324 is a reply to message #389312] Sat, 28 February 2009 11:38 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If I understood correctly what you have said, you have described expected master-detail behaviour.

Quote:
can u please make a sample form for this.
No, I don't want to.
Previous Topic: calling procedure
Next Topic: Calling Database Procedures/functions from Oracle Forms
Goto Forum:
  


Current Time: Sat Dec 03 15:51:17 CST 2016

Total time taken to generate the page: 0.04621 seconds