you should be using a form to enter your data and should not be entering data directly into tables. This can be easily accomplished by setting up a relationship between the tables and then creating sub forms to your main input form. This will automatically update all the tables concurrently.