Marketing wants to change the appeal that a particular source lives under. I understand what to do:
update tx_appeal_media_typeset appeal_no = xxxwhere source_no = xxx
Will this cause problems? Yes, the source already has contacts.
Thanks!
One issue you may have is that the Appeal_no is stored along with source_no in t_order and t_promotion, for example. So, this is not as simple as just updating tx_appeal_media_type.
Perhaps someone has some code they'd be willing to share that would update all the appeal_nos based on source.
David