Edit the ItemCode as Primary key, of Inventory

[hfsitumo2001]

Hello, I just suppose a user make a new itemcode(in inventory table itemcode is a primary key), say "40x42C", that should have been "40x42B", then the user already make a receipt transaction for this item code. The table below is the db relationship. When I tested to change it to "40X42B" , an error message saying " the change can not be changed, because it is being used in Purchase Detail/Sales details (see picture below).

My question is that the behavior of the primary key?, Probably we can change item code, when we created, but have never been used yet for transaction?. Thank you for any idea, because I have to make a presumption so that I know how to handle it.

 

[theDBguy]

Make sure you have a backup and then try using Cascade Update.

 

[hfsitumo2001]

Make sure you have a backup and then try using Cascade Update.

What is Cascade update DBGuy...

 

[hfsitumo2001]

Make sure you have a backup and then try using Cascade Update.

Thank you, I see the sample on youtube... I understand now

 

[theDBguy]

Thank you, I see the sample on youtube... I understand now

Hope it works for you. Good luck!

 

[arnelgp]

it's Unlikely situation, when there is already a PO and Receipt?
Item code are created by top management, not by user level.

 

[gemma-the-husky]

it's Unlikely situation, when there is already a PO and Receipt?
Item code are created by top management, not by user level.

I don't know about that. In my experience, top management leave details to the troops, and the end result is often duplicatio, effectively by "near" duplication.

Product names with variations such as mm, MM, mm., MM. and so on, because it's easier to let user create the items they need than to set up a system for careful management of the items.

 

[arnelgp]

don't know about that. In my experience, top management leave details to the troops, and the end result is often duplicatio, effectively by "near" duplication.

then you have poor management.
on my experience, there is first "material take-off", before anything else.

 

[hfsitumo2001]

it's Unlikely situation, when there is already a PO and Receipt?
Item code are created by top management, not by user level.

Ok, thank you Arnel, we are not a big company, we are just school's housekeeping dept. So actually it is ok, I have made it, and I think it is very rare to revise the item code