We have two fields containing codes the front end users would like to free text search on, I’ve tried a couple of the methods, the search object and the search icon in the caption bar of a list box but none appear to work or easy to use. I use (combine) the two fields in either the search box or List box properties.
The two fields for demonstration purposes are
Search_Field_1 contains text in the format (example codes in one string) A020, E119, D573, H875, etc…….
Search_Field_2 contains text in the format (example codes in one string) Z272, D857, F968, L756, etc….
I would like the user to be able to type (in either the search text object or List Box search depending which method works best) E119 H875 Z272 and it matches the records. Unfortunately I can't get this to work. I’ve tried the“Use Wildcard Search” and “Use normal search” but they don’t appear to work, I’ve tried searching this and other sites for information but its conflicting and unclear on the format you have to use.
I’ve tried this format (*E119*|* H875*|* Z272*) but this would be unacceptable for the user to type in this format each time.
TIA
Andrew
.png "Former Employee"){kind=icon}
