I want to use lvs_tkt_hist to display the zone in list builder. When I use t_zone as the RefCol, zone_no as the IDCol, and Description as the description column, I am getting duplicate values in the drop down (many zones are tied to different zone maps). Do I need to create a view to select distinct descriptions from t_zone? Or create a view from lvs_tkt_hist and add the zone description to that? Or...is there a way I can sneak Distinct into List Builder?
It's a little different, but if memory serves I was doing a similar thing with report setup (doing something clever to restrict or reformat the menu text options) and it stopped working in V11. I'd go ahead and make the view: they're cheap and will make your configurations easier to maintain.
--Gawain
Which is to say I'd probably do the first thing (view on T_ZONE).