I am developing an Access Application using Access as the front end database and SQL Server as the Back end database.
I have a table named tblA with fields FldA, FldB, FldC and FldD.
I have another table named tblB with field FldA, FldB, FldC and FldD.
When tblA.FldA = tblB.FldA, I want to populate
tblB.fldC with the value in tblA.fldC and
populate tblB.fldD with the value in tblA.fldD
Do you know how I could accmplish this SQL Update ?