I have a task to clean up a data set. I have one table (b) that has an employee id and a combined last name, first name field. Another table (a) contains other data along with a first name and last name field. I am using a combo box to do a look-up by name and auto populate the other fields. Is it possible to build a combo box that will filter the combo name field LIKE the last name field in the form?
In other words my task is to assign employee ids to all employees listed in table A. I thought the task might be easier if there a way to filter the combo box so that it displays names that begin with last name that is displayed on the form. If Robinson is the name in the last name field can I filter the combo box to select data that appears as Robinson, John.....Robinson, Mary in the look up table. Possible?