hfsitumo2001
Member
- Local time
- Today, 00:02
- Joined
- Jan 17, 2021
- Messages
- 365
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.
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.