I'm trying to have a combobox look up results from two columns but still bound to column 1.
That is, with Column 1 [Last Name] and Column 2 [First Name], I'd like the combobox to filter the list by both columns, but then bound the selection to Column 1 [Last Name]
I'm trying to do that with a union query, but can't find a way to bound it to Column 1.
That is, with Column 1 [Last Name] and Column 2 [First Name], I'd like the combobox to filter the list by both columns, but then bound the selection to Column 1 [Last Name]
I'm trying to do that with a union query, but can't find a way to bound it to Column 1.