Master-Detail in Same Table - Oracle Form 2.5

From: PPP <navikp_at_gmail.com>
Date: 3 Jan 2007 13:52:39 -0800
Message-ID: <1167861159.658873.179470_at_i80g2000cwc.googlegroups.com>

[Quoted] Hi All, Need help in following. I have following form layout based on one table only... This is layout

Set Name Set Code

Period: Period1 Period2 Period3 Period4

Value(Record1): Value1 Value2 Value3 Value4
Value(Record2): Value1 Value2 Value3 Value4
Value(Record3): Value1 Value2 Value3 Value4
Value(Record4): Value1 Value2 Value3 Value4
Value(Record5): Value1 Value2 Value3 Value4

Period value is based on Set Name and will be constant but the value will be different
so when the value in Set Name Change the Period values should change...

Following is table structure

Record 1: set name,set
code,period1,value1,period2,value1,period3 ,value3, period4,value4,period5,value5
Record 2: set name,set
code,period1,value1,period2,value1,period3 ,value3, period4,value4,period5,value5
Record 3: set name,set
code,period1,value1,period2,value1,period3 ,value3, period4,value4,period5,value5
Record 4: set name,set
code,period1,value1,period2,value1,period3 ,value3, period4,value4,period5,value5

So every record in table has period values but in form requirement is not to show period field values as for a set name period value will be same but value field values can differ so depending on set name i want to change label in period text field.

So created a view on distinct set name as master block and detail block as base table so i can see desired data view in form

Master block ( view) shows - set name,set type, period 1 to period 5 Detail block (base table) shows - value 1 to value 5. for period 1-period5 in detail block i have given NULL in their canvas so it will not show up in form.

now i have a problem with insert/update. created a pre-insert / pre-update trigger on detail block but it does not insert period values in table only insert value field.

Need help on this
Thanks in advance Received on Wed Jan 03 2007 - 22:52:39 CET