Forms 4.5 help Master Detail Display Problem

From: D Morrow <morrowd_at_ci.portsmouth.va.us>
Date: 1997/09/03
Message-ID: <01bcb880$657ac2c0$1e01070a_at_MorrowD.ci.portsmouth.va.us>#1/1

Sorry in advance for the length of posting, but I wanted to explain the situation thoroughly.

I'm sure some of you Oracle gurus have encountered a similar problem and I would appreciate any advice.
Here's my table design:

Table M1 		Table D1
applicant_id		applicant_id
name			exam_type
			exam_date
			section_no
			score

The exam_type and exam_date may be duplicated for up to four section_no's: Data may look like this --

1	P	1/1/97		1	80
1	P	1/1/97		2	90
1	F	2/1/97		1	87
1	F	2/1/97		2	88
1	F	2/1/97		3	90
2	P	1/1/97		1	70

Would like my form to look like the following but don't know how??

+----------------------------------------------------------+
|     applicant_id  _____				|


|						|

|- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - |
|  Exam Type   P	Exam Date    1/1/97	|


|						|

|  Section #		Score			|
|         1			80			|
|         2			90		  	|


|						|

+----------------------------------------------------------+

The Exam Type and Exam Date should be a summary with the sections below. Problem is when scrolling thru recs at Exam Type, type and date are repeated for each section #. Any help would be greatly appreciated.

Please email any responses in addition to posting.

Thanks Received on Wed Sep 03 1997 - 00:00:00 CEST