• Replies 4 replies
  • Subscribers 336 subscribers
  • Views 117 views
  • Users 0 members are here
Related

Constituencies

Former Member
Former Member $organization

Can someone tell me which table stores a customer’s constituencies?  I know the table tr_constituency stores the names of the possible constituencies, but it does not connect to the customer_no.  Which table will show me that customer_no 19996 has constituency ID of 18?

 

Thanks in advance!

 

 

Penny Tabor

IT Manager

Midland Center for the Arts

Midland, MI 48640

                            acerp

 

 

Parents
  • $organization

    Hi Penny,

    It’s TX_CONST_CUST .  Or you can use the view  VX_CONST_CUST_ACTIVE  which selects only accounts with active constituencies.

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Penny Tabor
    Sent: Monday, October 04, 2010 2:08 PM
    To: Hoffmann, Tanya
    Subject: [Tessitura Technical Forum] Constituencies

     

    Can someone tell me which table stores a customer’s constituencies?  I know the table tr_constituency stores the names of the possible constituencies, but it does not connect to the customer_no.  Which table will show me that customer_no 19996 has constituency ID of 18?

     

    Thanks in advance!

     

     

    Penny Tabor

    IT Manager

    Midland Center for the Arts

    Midland, MI 48640

                                acerp

     

     




    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!



    This e-mail message is intended only for the recipient(s) named above. This message may contain trade secrets, attorney-client communication, or other privileged and confidential information. Any review, re-transmission, dissemination, reproduction or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the Sender and delete the material from any computer.
Reply
  • $organization

    Hi Penny,

    It’s TX_CONST_CUST .  Or you can use the view  VX_CONST_CUST_ACTIVE  which selects only accounts with active constituencies.

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Penny Tabor
    Sent: Monday, October 04, 2010 2:08 PM
    To: Hoffmann, Tanya
    Subject: [Tessitura Technical Forum] Constituencies

     

    Can someone tell me which table stores a customer’s constituencies?  I know the table tr_constituency stores the names of the possible constituencies, but it does not connect to the customer_no.  Which table will show me that customer_no 19996 has constituency ID of 18?

     

    Thanks in advance!

     

     

    Penny Tabor

    IT Manager

    Midland Center for the Arts

    Midland, MI 48640

                                acerp

     

     




    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!



    This e-mail message is intended only for the recipient(s) named above. This message may contain trade secrets, attorney-client communication, or other privileged and confidential information. Any review, re-transmission, dissemination, reproduction or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the Sender and delete the material from any computer.
Children
No Data