I am linking two tables and updating one table. The query runs with no errors but does not update the MFOEDL table? Below is the code..
UPDATE TblMFOEDL INNER JOIN TblTL ON TblMFOEDL.docno = TblTL.DOCNO SET TblTL.fc = [TblTL].[fc];
I am linking two tables and updating one table. The query runs with no errors but does not update the MFOEDL table? Below is the code..
UPDATE TblMFOEDL INNER JOIN TblTL ON TblMFOEDL.docno = TblTL.DOCNO SET TblTL.fc = [TblTL].[fc];
UPDATE TblMFOEDL INNER JOIN TblTL ON TblMFOEDL.docno = TblTL.DOCNO SET TblTL.fc = [TblTL].[fc];
you did update, but new value is same as old value.
omg THANKS for the insight!! been looking at this DB to long!