Multiple field search

[#1]

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

Example:

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?

[MarcoWedel]

Maybe a search box restricted to search only in your Account- and ProjectName fields could be a solution.

You could also change the search mode to match your requirements.

hope this helps

regards

Marco

[prieper]

You may also concatenate both fields and display in a listbox (with seach-functionality).

HTH Peter

[#4]

I have tried the  concatenated listbox but cannot get the "Input box" value to select the possible values. 

[MarcoWedel]

Hi,

maybe like this:

=ValueList($(=chr(39)&GetFieldSelections(AccountName,chr(39)&','&chr(39))&chr(39)),$(=chr(39)&GetFieldSelections(ProjectName,chr(39)&','&chr(39))&chr(39)))

hope this helps

regards

Marco