J
Jedit
I have a database that holds information on materials, we blend different
powders say T N C I & M to create a grade of material HA/HE???. The tables I
have are
tblMechtest
Mecht_id unique record
Mat_ID Material type lookup from material grades 1-9
Batch# Batch number assigned to material is always new
Pow-Hist History of powder i.e. Rc1, Rc2, Rc3, New
Entry Date Date record is entered into dbf.
tblNewPowder
NPOW-ID Linked to Batch# tblMechtest
Rawmat being T N C I or M (looked up from tblRawmaterials )
Weight How mutch of the raw mat has been used
MI-Batch Suppliers Material batch number
tblRawmaterials
rawmat_id unique record
material T N C I or M
tblRecrush (contains the batch numbers & quantities blended together)
RC-ID Linked to Mecht_id from tble Mechtest
RPOW-ID Re-used powder batch number
Weight Weight of powder.
From here on, when I talk about a batch number, this is a blend of raw
materials being T N C I or M or a previous mix being blended with others.
tblMechtest holds info about all new batches
What I am trying to do is to create a family tree for traceability, by
typing in a batch number I want to display all new batches & re-crush batches
with all the raw material names & associated supplier batch numbers.
An example would be
931
897 T N C
920 T N C
903===== 621 T N C
809 T N C
795 T N C
796 T N C
831======
832======
Definition of re crush : new powders that have been used and & crushed down
then mixed together with other batches.
powders say T N C I & M to create a grade of material HA/HE???. The tables I
have are
tblMechtest
Mecht_id unique record
Mat_ID Material type lookup from material grades 1-9
Batch# Batch number assigned to material is always new
Pow-Hist History of powder i.e. Rc1, Rc2, Rc3, New
Entry Date Date record is entered into dbf.
tblNewPowder
NPOW-ID Linked to Batch# tblMechtest
Rawmat being T N C I or M (looked up from tblRawmaterials )
Weight How mutch of the raw mat has been used
MI-Batch Suppliers Material batch number
tblRawmaterials
rawmat_id unique record
material T N C I or M
tblRecrush (contains the batch numbers & quantities blended together)
RC-ID Linked to Mecht_id from tble Mechtest
RPOW-ID Re-used powder batch number
Weight Weight of powder.
From here on, when I talk about a batch number, this is a blend of raw
materials being T N C I or M or a previous mix being blended with others.
tblMechtest holds info about all new batches
What I am trying to do is to create a family tree for traceability, by
typing in a batch number I want to display all new batches & re-crush batches
with all the raw material names & associated supplier batch numbers.
An example would be
931
897 T N C
920 T N C
903===== 621 T N C
809 T N C
795 T N C
796 T N C
831======
832======
Definition of re crush : new powders that have been used and & crushed down
then mixed together with other batches.