Ex:
I have to tables TABLE-A, TABLE-B

CREATE TABLE A(HEADER_ID NUMBER(4) PRIMARY KEY,BROKER_CODE VARCHAR2(10),E_DATE DATE,AGENT VARCHAR2(10)) 

CREATE TABLE B(LINE_ID NUMBER(4) PRIMARY KEY,HEADER_ID NUMBER REFERENCES XX_JVG_HEADER(HEADER_ID),INVOICE_NO NUMBER(4),LOT_NO NUMBER(4))

1) I will insert the data manually raaa.I'm taking HEADER_ID as a Primary Key in Table-A & Foriegn Key in Table-B.
2) Again i have taken LINE_ID as a Primary Key in Table-B .If i try to insert the data into Table-B the HEADER_ID automatically should enter in Table-B.
3) But the HEADER_ID should be the same for Table-A & Table-B.

Table-A
2,'abc','12-mar-2002','chennai'

Table-B
1,2,1,1

Header_id should be same in 2 tables i.e -- 2
we have to create triggers or any...pls let me know ASAP.

If any one is having the coding u can pls send me to siva_gonuguntla@yahoo.com