take the value from another table

[pivoine1342]

I have field in a table Employé that needs to take the value from another table Impôts new.zip

[ranman256]

The impots table MUST have a field to join to Employe, either Emp#, or EmpName.
if you had 1 of these fields , you would run an update query by joining the same field in both tables.

[June7]

So you want to populate Employe with the Nimpot and impot values? Why? Already have the salaire value in Employe - why do you also need the other info? Duplicating data between tables violates basic relational database principle.

Just build query that joins the two tables by linking on the salaire fields.

What is the degree symbol in field names for - abbreviation for number? Should not use symbols and punctuation in naming convention (only underscore is exception).