Help with Key Value and Template

[Martina_Hawkins]

I have a table Equipment
Item Id - Key
Item Category
Item Description
Location
…

I have a table called Costs
Cost Ref No - Key
Item Id
Cost Type
Cost
…

I have a table called Total Costs
Summary Id - Key
Total Costs

Total Costs is calculated in Excel - Sum of column Cost in Costs Table

I have a workflow to create a Costs Report
Workflow is based on Total Costs so Total Costs will show at top and then details below.
Item Id Category, Description, Cost Type, Cost

I recently changed the structure of the Costs table. Previously the key was Item Id. I had to change this to add a Costs Ref No as an Item may have multiple costs - Purchase, repair, service costs

The workflow worked before but not know with the new key

I have a VC in Costs called Category to pull the Category in from the Equipment table

This no longer works with the Key change and therefore the report cannot find Category

Any help appreciated.