Currently, i have created a table for each employee. the table lists down the targets for each employee. Since the targets overlap, i want to define a way in which i can update the overlapped targets from one location.
for example the revenue targets for all employees are same. i do not want to go and manually enter the revenue target for each of the employee.
i want to create a form in which i can enter the data once and it automatically udpates the revenue target field in all of the tables for each of the employee.
This way, all of your data is contained in one table and you can update any of the records w/ out resorting to overly complicated queries. It's not a good prcatice to have the same data in multiple tables.
Just a sugestion.
Even if I consolidate into one table, I would still have to enter the values multiple times. Is there a way to avoid having to enter data multiple times so that when I update the value in one field, it automatically updates in all other fields.
So in this case if I have on table, I would need to have one entry for each of the employees. Example:
Employee ID Target Description Target
1 revenue 100 million
2 revenue 100 million
3 revenue 100 million
and so on and so forth. so i would be entering the value 100 times if i have 100 employees with the same target. Am I understanding you correct?