In the MS Access file, “FL Pension OPEB.mdb”, update the MunID in the imported table by joining with the lookup table “Lookup_Master_MunID_Name”: UPDATE Lookup_Master_MunID_Name INNER JOIN [FASB Funding Progress] ON Lookup_Master_MunID_Name.TrfDescription = [FASB Funding Progress].TrfDescription SET [FASB Funding Progress].MunID = [Lookup_Master_MunID_Name].[TrfMunID];

Update the Fund Type ID by joining with the lookup table: UPDATE t_fundtype INNER JOIN [FASB Funding Progress] ON t_fundtype.TftCode = [FASB Funding Progress].TrfType SET [FASB Funding Progress].TrtID = [t_fundtype].[TftID];