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.
I would make a custom view that show all of T_inventory plus a column for season number by joining to t_prod_season and then you can use that as the Dddw_Table value. Then in your where, you can just say season = xx
Christian @ The Tech Museum