Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » creation on Master detail form problem (oracle XE apex)
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


Previous Topic: Query - Apex
Next Topic: APEX INSTALLATION PROLEM
Goto Forum:
  


Current Time: Thu Mar 28 04:38:29 CDT 2024