Unanswered: updating same field in multiple tables
I have created a employee target database as follows:
Table: Employee Title_Target
So for each employee title I have created a table with the targets.
Now sometimes there are some common targets for employees with different titles. But since I hace created these targets in each of the tables, currently I have to go and manually enter the same target in each of the different tables. I was wondering if there is a way to create a form or something in which when I enter the data it gets updated in all tables which have the same targets.