View Single Post
  #4  
Old April 3rd, 2010, 07:51 AM posted to microsoft.public.access.tablesdbdesign
JonB
external usenet poster
 
Posts: 11
Default Updating relationships

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.