remove order from performance

Hello,

Does anybody have any suggestion on how to deal with this issue?

We have an order that needs to be deleted. Here's the situation:  We built a rental show and did some test orders.  The production company then decided to change their mind on the zone map we will use.  We cannot re-assign the zone map for this performance because there are 'orders' on this show...even though the tickets were released.  We needed to move forward with this build, so we copied the show and procedeed.  However, we now have a show that needs to go away.  The order that was created for the show was a test order. Our assumption is that if we are able to delete the order then we will be able to delete the show as well. Is this true? If so, is there a way to delete the order without sifting through all the order tables and deleting the related entries?

Thank you!!