No useful title

[cap.zadi]

i will be greatful if u give me some advise about: if we consider the same last my table details. so when we go to the record the reject data so it can be many bcz of reject reasons? so how to control that in one transaction that if there is



good pc's = 30
reject pc's = 10 (Crack = 3, Bend = 2, xyz=5) so how we can manage to add those 3 type of reasons and values in same transaction?

will be waiting for u kind advise plz.

thanks.

zee

[cap.zadi]

Hey there, hope things are fine.

dear i would like to ask and will take ur some time for ur kind attention plz.

tble1

Trn_Date
Shift_ID
Machine_ID
Emp_ID
Emp_Name

Item_Name
Passed_Qty
Reject_Qty
Reject_Reasons

so what i am looking to do here is?

1. i want to hold the values of 1st part as long as not going to change in a form bcz when i have many transaction so need to tab every time all the 1st part which is some times same for 20 or more transactions?

2. in 2nd part of the tble, there is always some reject qty like 10 pc's but from 10 pc's there are different reasons like 5 pc's crack and 5 pc's bend so how to manage this area in one transaction enter more than 1 reasons?

i will be greatful to you.

thanks

zee