I have two databases. One is an employee record and the other one is a payroll. In the payroll file I have a field that you can choose the individual to pay by looking up their name from the last name field in the employee database. I have the field as a pop up list using the last name field from the employee database as the value list. The problem is that the list will not show people with the same last name. The list only contains the first record entered with that name spelling. First, is this the best way to do this and if so is there a way to get the value list to show all of the records in the database?
