Auto-complete not searching multiple fields

[cbrent]

It appears that the database driven textbox auto-complete function is not searching multiple fields. I have two fields listed in choice options field that are comma separated. When entering text only the first field is being searched. The second field is displayed to the right but is not searchable.

[Brian]

You are correct. This is by design.

If you need it to search both columns you can concatenate them into one. The auto complete functionality is building SQL statements in the background to search for your matches. So you can put the two columns together using something like this:

TRIM(FIELD1) || ' ' || FIELD2


This will display both fields separated by a blank, but also allow both to be searched.