I have accidentally merged a client request to the wrong workorder and now I can’t delete the item from the work-order without ayanova throwing a
violation of FOREIGN KEY constraint “FK_AWOITEMID” on table “ACLIENTSERVICEREQUEST”
error. In fact, I need to delete the client request permanently.
What is the best possible way to fix this?
Hi Mike
You can not delete the workorder or workorder item because it was created as a result of accepting the service request and linked to that service requerst; nor can you delete the service request because a workorder item has been created when it was accepted and is linked to that workorder item.
You can edit the workorder item - i.e. delete the text that was transfered from the service request to the workorder item , but you can not delete the workorder item itself, nor delete the service request to maintain database integrity