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 |
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 #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
|
|
|
Goto Forum:
Current Time: Thu Dec 05 19:08:29 CST 2024
|