OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » MASTER -DETAILS ENTRY FORMS IN APEX

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » MASTER -DETAILS ENTRY FORMS IN APEX

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

MASTER -DETAILS ENTRY FORMS IN APEX [message #432140]

Sat, 21 November 2009 21:40

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

Report message to a moderator

Re: MASTER -DETAILS ENTRY FORMS IN APEX [message #432228 is a reply to message #432140]

Mon, 23 November 2009 02:09

salwa
Messages: 76
Registered: December 2007

Member

NO SOLUTION FOR MASTER -DETAILS ENTRY FORMS?

Report message to a moderator

Re: MASTER -DETAILS ENTRY FORMS IN APEX [message #432273 is a reply to message #432140]

Mon, 23 November 2009 06:13

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

Report message to a moderator

Re: MASTER -DETAILS ENTRY FORMS IN APEX [message #432375 is a reply to message #432273]

Mon, 23 November 2009 20:05

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

Attachment: MasterDetialsCustomSolution1.sql
(Size: 206.22KB, Downloaded 2872 times)

Report message to a moderator

Re: MASTER -DETAILS ENTRY FORMS IN APEX [message #432377 is a reply to message #432375]

Mon, 23 November 2009 20:40

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 2438 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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 19:49:08 CST 2024