Hi to everyone,
I have an Employee name and contact details table. I also have a Contract table. Some employees have two contracts. I have created a form to update data in Contract table. The Employee table primary key has been put in the Contract table as a foreign key. The Contract table does not have employee names but is linked to the names in the Employee table by the keys. I have used a combo and disabled it and covered the scroll button so as to show the name of employee in the Contract table. I am trying find a way of putting in a search so that users can look up contracts by employee name. Is there a way to do this?