insert into primary froeigon key relationship

[mimranp]

Hi every one
i want to insert into tx_category table data coulmn cat_type while selecting existing types from tx_type table.these two table are linked primary foreigon key relationship

INSERT INTO TX_CATEGORY(CAT _ID, STATUS_VALUE,CA T_NAME,CAT_PRIM ARY_TITLE,CAT_T YPE,CAT_PRIMARY TEXT,CAT_PRIMAR YCONTEXT,SRC_ID ,CAT_SECONDARY_ TITLE,CAT_PRIMA RY_INDEX,CAT_UP DATEDBY,CAT_UPD ATEDON,CAT_CREA TEDBY,CAT_CREAT EDON) VALUES((select NVL(MAX(CAT_ID) ,1) + 1 from TX_CATEGORY),'" + Is_StatVal + "','" + Is_CatName + "','" + Is_pTitle + "','"+Is_CatTyp e +"','" + Is_pText + "','" + Is_pContext + "','" + Is_srcID + "','" + Is_sTitle + "','" + Is_pIndex + "','" + Is_UpdatedBy + "','" + Is_UpdatedOn + "','" + Is_CreatedBy + "','" + Is_CreatedOn + "')";

[r035198x]

Did you get an error with that then?

[debasisdas]

you need to insert to parent table first then only you can insert to child table to enforce rule of REFERENTIAL INTEGRITY.