Hi there,
I have been asked to move some Source Codes to a different Appeal, and was wondering if this is possible, and if anyone has done something similar in the past and has any advice?
My initial investigation suggests that the appeal_no in TX_APPEAL_MEDIA_TYPE and T_PROMOTION would need to be updated for those Source Codes.
Cheers
Kim
Thanks for that Bob,
If the source had not been transacted upon I notice that I can use the Delete Promotions and Sources then re-promote as Ranie suggested, but as there have been some transactions this would not be a clean process.
Hello Bob, can I check the above - when moving a source from one appeal to another it means that any transactions/ticket orders/contributions will still show the original Appeal no. ? If so, that is fine for our purposes, I just need to check that there are no other implications of doing this update query?.
Many thanks for your help
Brian (Royal Opera House, UK)