D
Del
I have a database that is going to be used to track the movement of
parts through the material handling group. This group receives parts
in from the warehouse (Which adds the received qty to the material
handler's inventory), upon request they release parts to the repair
department (which deducts the qty from the material handler's
inventory). When the repair department has complete the repair of a
part it is then sent back to the material handling department who in
turn sends the parts to the repack department to be packed and ready
for shipment.
When the repair center has completed the repairs on the part it is
sent back to the material handling department. When the repaired parts
physically arrive in the material handling area a material handler
will scan two bar codes (Part number and qty) which will add the qty
into the material handling inventory. The parts then will be taken to
the repack department. I need to then deduct the qty sent to the
repack department from the material handling inventory.
In real life the parts are dropped off in the material handling area,
scanned and moved to repack all at the same time. The reason for
scanning them into the material handling inventory is because
management wants to see details of every point where the part changes
hands between departments. So to conserve time I would like to make
two entries in the table when the scans take place. The first entry
would add the part number, qty, and status code RRC to the table, the
second entry would add the part number, qty and status code SRP to the
table.
Thank you!
parts through the material handling group. This group receives parts
in from the warehouse (Which adds the received qty to the material
handler's inventory), upon request they release parts to the repair
department (which deducts the qty from the material handler's
inventory). When the repair department has complete the repair of a
part it is then sent back to the material handling department who in
turn sends the parts to the repack department to be packed and ready
for shipment.
When the repair center has completed the repairs on the part it is
sent back to the material handling department. When the repaired parts
physically arrive in the material handling area a material handler
will scan two bar codes (Part number and qty) which will add the qty
into the material handling inventory. The parts then will be taken to
the repack department. I need to then deduct the qty sent to the
repack department from the material handling inventory.
In real life the parts are dropped off in the material handling area,
scanned and moved to repack all at the same time. The reason for
scanning them into the material handling inventory is because
management wants to see details of every point where the part changes
hands between departments. So to conserve time I would like to make
two entries in the table when the scans take place. The first entry
would add the part number, qty, and status code RRC to the table, the
second entry would add the part number, qty and status code SRP to the
table.
Thank you!