2 questions concerning multiple tables

[Brian3864]

I have 2 questions, the first is probably simple.
Let's say I have an employee table listing all employees and a sales table listing employees that have made sales. How can I create a query to show all employees that are not in the sales table?

The second question is this. Is there any way on an insert form, if a certain record exists, to automatically insert that record into a different table also entering a field from the existing record?

Thanks
Brian

 

[aleb]

For both questions yes.
1. use find unmatched query.
2. use append query.