• Replies 4 replies
  • Subscribers 338 subscribers
  • Views 52 views
  • Users 0 members are here
Related

T_Reference_Tables

Marty Jones
$organization

I have a custom system table that has a season column and a package column in which both use drop downs to populate those values. Is there a way that when the user selects the season, that the drop down for the packages only displays the packages from the selected season?

 

Thanks,

  • $organization

    Hey Marty -

    Provided that Parameter 1 is the season, putting this in the where clause of the package parameter should work.

    charindex(',' + convert(varchar, season) + ',' , ',' + <<p1>> + ',') > 0

    Best regards,

    Matt

  • $organization

    At this point, no dependent dropdowns in System Tables.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Marty Jones
    Sent: Monday, November 15, 2010 11:57 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] T_Reference_Tables

     

    I have a custom system table that has a season column and a package column in which both use drop downs to populate those values. Is there a way that when the user selects the season, that the drop down for the packages only displays the packages from the selected season?

     

    Thanks,




    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!

  • $organization in reply to Ryan Creps (Past Staff Member)

    Whoops, I should have read that one a little more closely. I was thinking of reports. My bad.

  • $organization

    Thanks Ryan.

     

     

     

    Marty Jones

    Director of Information Services

     

    Omaha Performing Arts
    1200 Douglas Street

    Omaha, Nebraska 68102

    P 402.661.8469

    Marty.Jones@omahaperformingarts.org

    www.omahaperformingarts.org

    For tickets, call Ticket Omaha at 402.345.0606

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Creps
    Sent: Monday, November 15, 2010 11:38 AM
    To: Martin A. Jones
    Subject: RE: [Tessitura Technical Forum] T_Reference_Tables

     

    At this point, no dependent dropdowns in System Tables.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Marty Jones
    Sent: Monday, November 15, 2010 11:57 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] T_Reference_Tables

     

    I have a custom system table that has a season column and a package column in which both use drop downs to populate those values. Is there a way that when the user selects the season, that the drop down for the packages only displays the packages from the selected season?

     

    Thanks,




    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 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!