I was using a mix of SQL and Design view. I just remade it in Design view from scratch and this is what I get now.
Here is the code it writes:
Code:
UPDATE TblMastertube, TblHeatsMaster
SET TblHeatsMaster.Heats = [TblMastertube]![Heat], TblHeatsMaster.C = [TblMastertube]![C]WHERE (((TblHeatsMaster.Heats)=[Forms]![FrmMastertube]![ImHeatCbo]));
I tried linking the heat fields in the relationship boxes above like so:
but then the result becomes null/blank (Would have attached picture but 5 image limit.
and here is the change in code when I link them:
Code:
UPDATE TblMastertube
INNER JOIN TblHeatsMaster ON TblMastertube.Heat = TblHeatsMaster.Heats
SET TblHeatsMaster.Heats = [TblMastertube]![Heat], TblHeatsMaster.C = [TblMastertube]![C]WHERE (((TblHeatsMaster.Heats)=[Forms]![FrmMastertube]![ImHeatCbo]));