I am building a form that links to another table. I need to search the contents of the table to add the record. The default behavior of a field linked to another table only allows the user to search the records by the information in the first column. But in my linked table the first column is only the last name.
I want the user to be able to search other columns, like the first name, county, etc. Is it possible to set a form up so that searching for records in another table searches multiple fields?
It appears someone asked this 2 years ago and did not get a response: