Re-naming a Membership Level

If it were me,  I'd delete the constraint make the changes and then add it back. Ugly. But it works. 

Matthew Hodge <bounce-matthewhodge3604@tessituranetwork.com> wrote:

Here's a question: If I want to re-name a membership level (as in the three-character code), I know it needs to be changed in T_MEMB_LEVEL and TX_CUST_MEMBERSHIP (because you can’t change it in the front-end). But there’s a foreign key constraint that catches you if you change either one of those. Is there a quick and easy way to get around that?

 

Cheers,

 

 

Matt

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

If it were me,  I'd delete the constraint make the changes and then add it back. Ugly. But it works. 

Matthew Hodge <bounce-matthewhodge3604@tessituranetwork.com> wrote:

Here's a question: If I want to re-name a membership level (as in the three-character code), I know it needs to be changed in T_MEMB_LEVEL and TX_CUST_MEMBERSHIP (because you can’t change it in the front-end). But there’s a foreign key constraint that catches you if you change either one of those. Is there a quick and easy way to get around that?

 

Cheers,

 

 

Matt

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!