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”.
It would be difficult to answer your question, without knowing what customization involved here?
Please don’t hesitate to provide enough information.
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?
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?
ABC_Table.ItemId = inventTable.ItemId;
It will not help unless we know when the record is being inserted?