Update query in ms access

[lienlee]

UPDATE ExportToTable LEFT JOIN Integration_Interface ON ExportToTable.ID = Integration_Interface.Integration_Interface_ID SET ExportToTable.I_I_name = [Integration_Interface].[Integration_Interface_Name];

When i hit run to run this query. nothing happens. is something wrong with my query?

attached is the relationship between the two tables

[XLGibbs]

When you say "nothing happens"...there is no error message...nothing at all?

What happens when you run this:

Select ExportToTable.ID, Intergation_Interface.Integration_Interface_ID FROM ExportToTable 
 LEFT JOIN Integration_Interface ON ExportToTable.ID =  Integration_Interface.Integration_Interface_ID

Do you get results?

[HannaPearson]

Thank you for this. I got it working on my computer now.