Report question

Question: Insert record into table if entry does not exist in another table- with an extra twist