Hi all,

I have created a employee target database as follows:

Table: Employee_Detail
Employee Number
Employee Title
Employee Name
Employee Department

Table: Employee Title_Target
Employee Number
Target Description
Yearly Target
Yearly Actual

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.

Any help would be appreciated.

Thank you.

Best regards,

Uzair Moosa