help with Dddw_Where in T_REFERENCE_TABLES

I have created a custom table that I want to make available to users as a System Table. We are storing budget information for each prod_season_no and I want my users to be able to choose a production from a dropdown instead of relying on IT to provide the list of prod_season_no values.

I have added a season_no column to my custom table with the intent of letting users choose the season from a dropdown and then populating the prod_season_no values from another dropdown, just like in a Report. This will ensure that they choose the correct prod_season_no because we have many instances of the same production title being used in multiple seasons (though of course with unique prod_season_no values).

However, I am having trouble getting the Dddw_Where value for the prod_season_no column entry in T_REFERENCE_TABLES to "see" the selected value of the season_no column. What I want to do is the following:

 

column name: prod_season_no

Dddw_Table: t_inventory

Dddw_Value: inv_no

Dddw_Description: description

Dddw_Where: inv_no IN (select prod_season_no from t_prod_season where season = !.season_no)

 

This does not work. I am looking for a way to reference the selected season_no value. Any help on this matter would be very much appreciated.

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!

I have created a custom table that I want to make available to users as a System Table. We are storing budget information for each prod_season_no and I want my users to be able to choose a production from a dropdown instead of relying on IT to provide the list of prod_season_no values.

I have added a season_no column to my custom table with the intent of letting users choose the season from a dropdown and then populating the prod_season_no values from another dropdown, just like in a Report. This will ensure that they choose the correct prod_season_no because we have many instances of the same production title being used in multiple seasons (though of course with unique prod_season_no values).

However, I am having trouble getting the Dddw_Where value for the prod_season_no column entry in T_REFERENCE_TABLES to "see" the selected value of the season_no column. What I want to do is the following:

 

column name: prod_season_no

Dddw_Table: t_inventory

Dddw_Value: inv_no

Dddw_Description: description

Dddw_Where: inv_no IN (select prod_season_no from t_prod_season where season = !.season_no)

 

This does not work. I am looking for a way to reference the selected season_no value. Any help on this matter would be very much appreciated.

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!