Master/Detail/Detail block [message #389270] |
Fri, 27 February 2009 23:54  |
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 #389312 is a reply to message #389301] |
Sat, 28 February 2009 06:12   |
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  |
 |
Littlefoot
Messages: 21823 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.
|
|
|