Select all fields where value occur

[#1]

I've got 3 fields; ID, Name1, Name2. I've created an input box with a list of all the names that may occur in either field. Now I want to create a Select field-action that finds any occurence of the name. I guess I need to create a fourth field in the script that merges all names, and then do a wildcard search in that field and select the ID-field when a match is found. If that is the correct solution, what is then the correct search string syntax?

Example:

ID	Name1	Name2
1	John	John
2	Lisa	Anna
3	John	Ruth
4	Anna	Peter
5	Peter	John

If I select "John" in the input box the following should be selected:

ID	Name1	Name2
1	John	John
3	John	Ruth
5	Peter	John

How do I accomplish this?

Thanks in advance

[swuehl]

IMHO, selecting in ID field is the right approach.

You can create a Select - Select in field action for a button action and then create a search string like

='=Name1=' &chr(39)& $(vInputBox) &chr(39) ' or Name2=' &chr(39)& $(vInputBox) &chr(39)

[#3 · Accepted solution]

Excellent, thank you a lot! There was an ampersand missing and by removing the $-sign (don't know what it does). I got it working with this formula:

='=Name1=' &chr(39)& vInputBox &chr(39) & ' or Name2=' &chr(39)& vInputBox &chr(39)