A selection list in the software provides a list of the possible values for a cell or field so you can easily pick a value. When you click in a cell with a selection list available, the green arrow icon appears on the toolbar. You can use the Find box to search in the Selection list dialog box.
-
By default, the Find functionality searches in the lookup column only.
-
If you want to search in all columns, type an initial %, for example: %Sam. For this kind of search, only the columns with character data are included in the search. In addition, the search is not case-sensitive, for example, Asd, aSd, and ASd are considered similarly. When you search only in the lookup column without entering an initial %, the search is case-sensitive. For example, Demo does not match DEMO.