Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » MASTER -DETAILS ENTRY FORMS IN APEX
MASTER -DETAILS ENTRY FORMS IN APEX [message #432140] Sat, 21 November 2009 21:40 Go to next message
salwa
Messages: 76
Registered: December 2007
Member
THIS IS MY TABLE, HOW I WILL MASTER -DETAILS ENTRY FORMS IN APEX.
PLEASE HELP


CREATE TABLE BUY_INFO_MST
(
SUPPLIER_CODE VARCHAR2(5) NOT NULL,
MEMO_CODE VARCHAR(12),
ITEM_CODE VARCHAR2(3) NOT NULL,
BUY_DATE DATE ,
USER_NAME VARCHAR2(15) ,
ENTRY_DATE DATE ,
UPD_USER VARCHAR2(15) ,
UPD_DATE DATE ,
CONSTRAINT PK_BUY_INFO PRIMARY KEY (SUPPLIER_CODE,MEMO_CODE,ITEM_CODE,BUY_DATE)
);


CREATE TABLE BUY_INFO_DTL
(
SUPPLIER_CODE VARCHAR2(5) NOT NULL,
MEMO_CODE VARCHAR(12) ,
ITEM_CODE VARCHAR2(3) NOT NULL,
ITEM_DETAILS_CODE VARCHAR2(3) NOT NULL,
BUY_DATE DATE ,
ROLL VARCHAR2(3) ,
UNIT_CODE_M VARCHAR2(3) ,
UNIT_CODE_I VARCHAR2(3) ,
QUANTITY_M NUMBER(10,4) ,
QUANTITY_I NUMBER(10,4) ,
UNIT_PRICE NUMBER(15,4) ,
BUY_AMOUNT NUMBER(15,4) ,
USER_NAME VARCHAR2(15) ,
ENTRY_DATE DATE ,
UPD_USER VARCHAR2(15) ,
UPD_DATE DATE ,
CONSTRAINT PK_BUY_INFO_DTL PRIMARY KEY (SUPPLIER_CODE,MEMO_CODE,ITEM_CODE,ITEM_DETAILS_CODE, BUY_DATE),
CONSTRAINT FK_BUY_INFO_DTL FOREIGN KEY(SUPPLIER_CODE,MEMO_CODE,ITEM_CODE,BUY_DATE)REFERENCES BUY_INFO_MST
);

JAHANGIR
Re: MASTER -DETAILS ENTRY FORMS IN APEX [message #432228 is a reply to message #432140] Mon, 23 November 2009 02:09 Go to previous messageGo to next message
salwa
Messages: 76
Registered: December 2007
Member
NO SOLUTION FOR MASTER -DETAILS ENTRY FORMS?
Re: MASTER -DETAILS ENTRY FORMS IN APEX [message #432273 is a reply to message #432140] Mon, 23 November 2009 06:13 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
apart from multiple key index, if you keep one column as unique and refer it as foriegn key, you shall be able to create master-detail form in no-time. Since apex master-detail wizard are splendid with one key reference. May be it is possible through using ajax code. Smile
Re: MASTER -DETAILS ENTRY FORMS IN APEX [message #432375 is a reply to message #432273] Mon, 23 November 2009 20:05 Go to previous messageGo to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

Dear guys,

Attached (MasterDetialsCustomSolution1.sql) is the complete solution for master detials problem.
Its completely done manualy. in the example for database table EMP & DEPT table has been used.


Note : just download the attached file and import into your apex. Run and get your solution.



Thank you.

---M Kamal Hossain
Re: MASTER -DETAILS ENTRY FORMS IN APEX [message #432377 is a reply to message #432375] Mon, 23 November 2009 20:40 Go to previous messageGo to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

guys,

Attached (preview.pdf) is the preview that you will see after downloading and
importing file "MasterDetialsCustomSolution1.sql" .I would like to remind you again that i have used EMP & DEPT table and assume you have both tables in your database.


***After installing and run you will see a blank page dont worry just select page 3 instead of page 1 then run and see the actual view.

-- Kamal hossain
  • Attachment: preview.pdf
    (Size: 28.85KB, Downloaded 2439 times)

[Updated on: Mon, 23 November 2009 21:00]

Report message to a moderator

Re: MASTER -DETAILS ENTRY FORMS IN APEX [message #432378 is a reply to message #432377] Mon, 23 November 2009 21:14 Go to previous message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

guys.

After installing (MasterDetialsCustomSolution1.sql) if "Add row" button doesn't function then you have to change your region Number of that respective report (Emp info )from add row button.

if you go to the properties of "DETAILS_ADD_ROW" then you will see there is written in the URL properties

javascript:$a_report('14597822673054230',&HID_MAX_3.,5,5);


here '14597822673054230' is the region number you need to change it to your region number that shown after installing in your workspace.
Attached (regionNumberFind.pdf) in http://www.orafaq.com/forum/m/432379/110825/#msg_432379 will guide you how to find your own region number.

Thank you.

--kamal hossain

[Updated on: Mon, 23 November 2009 22:30]

Report message to a moderator

Previous Topic: Version control for application
Next Topic: to find region number of a report
Goto Forum:
  


Current Time: Thu Dec 05 19:08:29 CST 2024