I think you will need to be a little more specific in your question.
If you have a query that is not working, please post it here, and if possible, post your tables structure as well.
If you are getting some error message, let us know.
What about trigger on that “another” table which will update the Reporting Table.
The query used to get the last information wrom the table is:
SELECT TOP 1 RemainingShifts
ORDER BY ID DESC
Then to update the Reporting Template:
SET Datum = dbo.TSProductionCal.Datum,
Tyd = dbo.TSProductionCal.Tyd,
[Current_Prod_Shift] = dbo.TSProductionCal.[Current_Shft_Acc],
[Remaining_Prod_Shift] = dbo.TSProdbo.R_DEPENDENCYductionCal.RemainingShifts,
<annual_Shift_Remaining] = dbo.TSProductionCal.<annualDays_CntrU_Acc],
<annual_Shift_Completed] = dbo.TSProductionCal.<annualDays_CntrD_Acc],
[Production_Month] = dbo.TSProductionCal.[Production_Month_Acc]
INNER JOIN dbo.[Report Template] ON dbo.[Report Template].ID = dbo.TSProductionCal.ID
Problem is that this copied all information to the Report Template and I just need it to Update the Last Value from the TSProduction Table