Re: Master-Detail in Same Table - Oracle Form 2.5

PPP wrote:
> 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
>

Show us the contents of these triggers. Received on Fri Jan 05 2007 - 17:48:40 CET