Simple Update Query

[sdc1234]

Greetings:

I am at a bit of a loss here any help would be appreciated: I have a VOUCH table that I have inserted 2 blank fields into which are Cadre and Salary, what I wanna do is update the columns with the cadre and Salary tab from another table, ALL EMP table.

every time I run the update tab It is deleting all the information out of my EMP table, and no I am not clicking on the delete table function either, the reason for the update is that the data source is changing all the time..
any ideas...

vr
novice

[John_G]

Hi -

My suggestion would be to not have the Cadre and Salary fields in the VOUCH table at all; they are redundant. All you need to do is join the VOUCH and Emp tables in a query using (presumably EMp Number or some such), and then use the query when you need to.

I am assuming there IS a common field between the two tables, e.g. Emp No?

HTH

John

[sdc1234]

I do the last name and ssn but when i try and link the tables the query shows up comes up blank...i then try to change the relationship and still blank

Hi -

My suggestion would be to not have the Cadre and Salary fields in the VOUCH table at all; they are redundant. All you need to do is join the VOUCH and Emp tables in a query using (presumably EMp Number or some such), and then use the query when you need to.

I am assuming there IS a common field between the two tables, e.g. Emp No?

HTH

John

[John_G]

Can you post the fields in VOUCH and the fields in Emp, or better, can you post a screenshot of your query design, showing the relationships? That would help.

Thanks

John

[sdc1234]

when i ran it like this i get a bunch of duplicates

[John_G]

What do you mean by "a bunch of duplicates"? Are you getting more rows in the query results then there are in either of the two tables?

Lastname is not a good field to be making a join on - there could easily be more than one employee with the same last name. Try using SSN for the join - you know that one is unique in the employee table, and should give you the results you want.