使用MS Access中的另一个表中的值过滤表的正确方法?

I have a table of transactions with some transaction IDs and Employee Numbers. I have two other tables which are basically just a column full of transactions or employees that need to be filtered out from the first.I have a table of transactions with some transa