List boxes & triggers - auto selection based on another value
Hi all,
After much searching of the forums and not being able to find a solution I'd like to ask for your advice.
In the example I have given, we have a selection of 10 Companies within two areas.
I have a trigger that should automtically select the Area (in the Area list box) depending on which company is selected in the company list box, however it only seems to work for the first two companies in the list no matter what order they are in.
All i want to be able to do is select a company from the Company list, then the text box populate with the total spend per area that company is in. It works for company A and B in the list bit for no others, which is very frustrating.
