I have 2 fields which could contain an Account Name. I want to look in the 2 fields and pull all data from the fields containing the name. The Account name could be spelled differently in each. I do not want the user to have to do a global search and then select all matching values
AccountName =Design Studio
ProjectName = DesignStudio
I created an input box for the user to enter the name(s) and store into a variable. I created 2 list boxes, one for AccountName and one for ProjectName. I had to use Alternate state on each. I set a trigger on the variable from the input box to select the matching values in the 2 list boxes. I now want to take the values in each box and apply to my chart. How do I get this to work?