Possible to exclude data in a list box dynamically?
Hi,
(example attached)
I have an issue with calculated list boxes and wanted to know if someone has a better solution.
I want to only ever show one chart on the screen. The user can choose the chart using the chart list box. After selecting the chart they can see only the appropriate fields for that chart. They can then use the list box in the usual way but only ever see fields associated with that chart.
In my sample I when I click on the Summary chart I want to be able to see just the relevant fields (customer and status). then when I click on Status see that I have excluded customer. The closest I can get to this is the calculated list box but I can't see "status".
At the moment the only way around this I can see is to create multiple list boxes hard coded with the chart type. Is there a way I can do this in one list box?
