Yes, I think this is what I want to do.
So, I should set the Limit to List Property to Yes, and in the On Not in List event, I am assuming I need to run a macro to add the new record to table1?
I don't know the code to write, so I tried the Macro Builder but I don't see and AutoAdd function...