What is the best way to create a search for two name fields

I have two seperate name fields in a form.

Sometimes when I am searching for the 2nd Name, this does not show up unless it is the same as the 1st Name.
For example 1st name is James Brown and 2nd Name is Jules Brown, Jules will show up because Brown is in both names. However if the second name was Jules Brows, it doesn’t show up.

If anyone has set up a search between two columns, how have you done this?

Have you set the “Searchable” property on both columns?

1 Like