You need TransDate so as to see 'what was when'.

tblInstruction to have these --
InstructionID
Instruction
Tool

Either add InstructionID to Step or Transaction.

--
Build a little, test a little.


"JonB" wrote:

Actually, to clarify, I want to be able to query and get:

widget,batch,instruction,tool
A,66,1,WidgetStomper
A,66,2,WidgetPresser
A,99,3,WidgetHeater
A,99,4,WidgetFreezer

I really want to be able to see what tool each widget has gone through, but
we only track what goes into a tool by batch.