I have a table Equipment
Item Id - Key
I have a table called Costs
Cost Ref No - Key
I have a table called Total Costs
Summary Id - Key
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.