Hey all,
I need to create a database for a production line that will=
follow inventory thru finished product. Does anyone have any=
experience with that? I was thinking a prod table which will=
have the status change during different stages of product=
development (Ex: Inventory-WIP-Complete) with a parallel History=
table which tracks all status changes, who made them, etc. and a=
parallel Job table which shows where all inventory was assigned=
and to what pieces on the job. Of course everything would be=
normalized (hopefully 4th normalization) and there would be=
company tables, vendor tables, etc. all connected to the=
inventory and job tables. Can anybody shed any light on this? =
Does anybody have any examples of one that I may view? Am I=
even on the right track?