Dears
I need your help in this matter.
Case:
At the end of the process stage, there will be Kiln Car (lets say 10 cars/day) loaded with product (one type of product at one car) will come out from furnace and shall be inspected and results shall be declared in either three categories :
a.Good (
b.ReWork (if then shall select the reason)
c.Reject (if then shall select the reason)
Notes: There are different type of 9 products and each product had its own loading pattern like 71 Pipes/Car to 8 Pipes Per car (as attached below)
Requirement:
The Inspector shall be able to select the loading pattern format as per product and shall process the results via touch screen by clinking on the given position of pipes on the car and mark results against each position.
a. The position already inspected shall be disabled.
b. The summary results shall be visible on the form as total good, rejected and remaining to inspect.
c. The position wise report as same inspection format to be available for printing to see trends for quality by position.
d. A summary report to be available at the end of the shift to see total summary results by car and total.
e. etc
Notes: One shift can have many cars to inspect.
In my Opinion?
"TblFiredInspec"
TranID : Auto number (PK)
TranDate:
Shift:
Workcenter:
Inspector:
*Once Selected in start up of shift
"TblFiredInspecSub"
InspecID : Auto number (PK)
TranID : FK
Product: FK (from TblProducts) *Once product is selected then related loading format shall Pop-Up.
CarNo:
Question: Here, how to link the piece to piece inspection results and program all the above scenario?