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