I have a table full with employees structured as:

```
tblEmployees
+--------------+------------+-----------+-------+
| EmployeeID   |  FirstName |  LastName |  Wage |
+--------------+------------+-----------+-------+

```

I then have a table which the user can paste data into from an external software which looks like so:

```
tblImport
+------------+-----------+--------------+
| EmployeeID |  WorkDate |  HoursWorked |
+------------+-----------+--------------+

```

This will then go into another table (`HoursWorkedRecords`) which is structured the same way.

When I append from the import table to the main table what I would like is firstly:

* The append to check if the `EmployeeID` pasted into the `tblImport` table exists in `tblEmployees`, if so then it append to `HoursWorkedRecords`.
* Before importing check there are no duplicate records by the `EmployeeID` on that given `WorkDate`.

My question is how can I achieve this?