Error Cannot create a record in RelationShip

Hi,

Cannot create a record in Relation Ship between Cost Code and Item (ABC_Table). Item number: ABC
The record already exists.While assigning value to cost code field in release product form.Getting error like above.

But no more records related to this item “ABC” present in “ABC_Table”.

Regards,

It would be difficult to answer your question, without knowing what customization involved here?

Please don’t hesitate to provide enough information.

Hi,
I have customized field “CostCode” in release product form.this field is come from “ABC_Table”.whenever create new item and assign value to the Costcode field ,the error occurs like a" Cannot create a record in Relation Ship between Cost Code and Item (ABC_Table). Item number: ABC
The record already exists."

So you are selecting from the available list of cost codes (ABC_Table).
What is the relation between inventTable and ABC_Table? Can you shows us the properties of relation?

Hi,
Yes…Itemid is relation.

So the table ABC_Table also has Item id field. How the data is being inserted into the ABC_Table table?

yes…through relation.
if (!ABC_Table.RecId)
{
ABC_Table.ItemId = inventTable.ItemId;
}

It will not help unless we know when the record is being inserted?