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,CAT_NAME,CAT_PRIMARY_TITLE,CAT_TYPE,C AT_PRIMARYTEXT,CAT_PRIMARYCONTEXT,SRC_ID,CAT_SECON DARY_TITLE,CAT_PRIMARY_INDEX,CAT_UPDATEDBY,CAT_UPD ATEDON,CAT_CREATEDBY,CAT_CREATEDON) VALUES((select NVL(MAX(CAT_ID),1) + 1 from TX_CATEGORY),'" + Is_StatVal + "','" + Is_CatName + "','" + Is_pTitle + "','"+Is_CatType +"','" + 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.