I'm having a hard time finding a table (not system like TR_XREF_TYPE) that contains the constituent ID and Associations. Our Development staff would like to do a mass inactivation of a large number of staff associations that no longer are working with the donor.
Awesome, thank you so much that’s exactly what I was looking for! And thanks so much for the tip – I’ll definitely keep a close detailed eye on the corresponding associations.
Sarah Parker
Database Assistant
P 650.463.7173 F 650.463.1963
PO Box 50458, Menlo Park, CA 94303-0458 | http://www.theatreworks.org
Follow us on Twitter, Youtube, & Facebook!
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ken McSwain Sent: Tuesday, February 07, 2012 5:54 PM To: Sarah Parker Subject: Re: [Tessitura Technical Forum] Mass updating associations?
Hi Sarah
TX_XREF is where they live.
That's one that you need to be very careful with - there is a record for each side of the association, even for soft associations.
Ken
From: Sarah Parker <bounce-sarahparker6350@tessituranetwork.com> Sent: 2/7/2012 7:39:34 PM
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!