How to Manage this type of Data?

[cap.zadi]

Hello Sir,



I am working on the structure. can you advise me how to manage the structure at process level - 6

Where is if a quntity is reject so other form shud appear to enter the reasons with qunantites?

if i say there is 20pc's rejected so another form should appear where i can enter

10 = CC
05 = Bend
05 = Hole


Please advise the structure?

thanks

zee

[jzwp11]

Basically you are doing a quality inspection of a process/product, so I believe you need a new table tied to tblProductProcess


Let's say for example the the product/process yields 50 pieces of which 20 are rejected as you describe, so your data might look like this:

30 pieces: good
10 pieces: bad: CC
5 pieces: bad: bend
5 pieces: bad: hole

So you table might look like this

tblProductProcessQuality
-pkProdProcQualityID primary key, autonumber
-fkProdProcID foreign key to tblProductProcess
-Qty (a quantity field)
-txtQuality (a field to say the products are good or bad) I show this as a text field buy you could possibly use a yes/no field or you can use a number field 1=good 2=bad or even a foreign key to another table that has applicable choices)
-fkReasonID foreign key to a table that holds all possible quality rejection reasons