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.
Darrin,
Sorry, I did not understand your issue correctly the first time. Now I see your dilemma. I am not 100% sure, but am guessing that what you are trying to do will not work. I guess the next best thing would be to use a view to at least show both the Season and production in the drop down list so the user can make the right selection. My view includes season number so you include a where clause to exclude old seasons if you want.
Create view lv_season_production asselect i.inv_no,(s.description + ' - ' + i.description) as Production , s.id as seasonfrom T_inventory ijoin t_prod_season p on i.inv_no = p.prod_nojoin tr_season s on p.season = s.id
Just a thought.
Christian @ The Tech Museum