Multiple Table query

[mstng07]

Okay I have a question, I'm not sure if this is possible or not, but if it is how can i accomplish this?

I have multiple tables (6) in a database that have one common field in all of them which is Employee_Name. What i have is, all of the tables combined with a query. Without having to enter in the employee name 6 different times, i was wondering if there would be a way to just update the other tables within the query with the name?

Any help is greatly appreciated

THanks in advance.

 

[Rabbie]

It doesn't sound as if your data is properly normalized. You shouldn't have Employee name in 6 different tables. Much better to have the PK of your employee table stored as a foreign key in the other tables. Then if an employee changes their name you only have to change it in one place and you will pick it up automatically. You should check your design to see if it is properly normalised

 

[mstng07]

Here is what I have, This is for our HR dept. to enter in employee health insurance information. I don't know what I'm doing wrong, I'm still kind of new at this.

Ignore every other query except for main query.

 

[Rabbie]

Your design does NOT look normalised. See this thread for some good advice especially from the Doc_Man