| creation on Master detail form problem [message #360859] |
Mon, 24 November 2008 02:52 |
dr.s.raghunathan
Messages: 540
Registered: February 2008
|
Senior Member |
|
|
hi,
Master Table Name : Bill_Header
Id number primary key fetches values from id_seq
pur_sal_flag char(2) 'PU' for purchase 'SA' for sale
vendor_code char(5)
bill_no varchar2(30)
bill_total number(16,2) (sums all details records of inv_qty*
inv_unit_Rate through trigger)
Detail Table Name : Bill_detail
Id number primary key fetches values from id_seq
pur_sal_flag char(2) 'PU' for purchase 'SA' for sale
vendor_code char(5)
bill_no varchar2(30)
inv_code char(5)
inv_qty number(16,4)
inv_unit_rate number(16,2)
So far I have created Id as a linking key to create master detail form in apex 3.1
Is it possible to combine three columns ( pur_sal_flag,vendor_code,bill_no) to establish relation between master and details and can create master detail form.
I did it through Forms 4.5 Oracle 7.2 In Apex 3.1.2 i am unable to establish more than one column as linking to create Master detail form. Infact I have created foreign key references for multiple columns. am i skipping or not seen the provisions made anywhere. and one more thing i am unable to create foriegn key references for multiple column through object browser. since referred columns are alphabatical order and skipping intermittant columns are not permitted. Ofcourse, i solve this issue writing triggers through sql command mode instead of using object browser. Hence my prime question on combining multiple columns for creating master detail pages are welcome.
yours
dr.s.raghunathan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
