AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Merging client requests to work orders Expand / Collapse
Author
Message
Posted 3/5/2007 6:03:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 4/27/2007 10:38:34 AM
Posts: 3, Visits: 9
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?

- Mike

Post #2880
Posted 3/5/2007 7:39:38 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 4:59:45 PM
Posts: 1,868, Visits: 4,328
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

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2881
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 3:50am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.109. 13 queries. Compression Disabled.