E
EMILYTAN via AccessMonster.com
I have JobNo (Old), JobNumber(new) (both of this place under the same field
of JobNo) and a ItemID.
My comparison goes like this:-
1. Check whether the JobNo (old) exist is the table
2. Check whether the JobNo(new) exist in the table
3. Compare whether the ItemID that belong to both of the job same...
If same transfer the quantityKitted to to the quantityKitted that has the
same partNumber of the JobNo(new)
of JobNo) and a ItemID.
My comparison goes like this:-
1. Check whether the JobNo (old) exist is the table
2. Check whether the JobNo(new) exist in the table
3. Compare whether the ItemID that belong to both of the job same...
If same transfer the quantityKitted to to the quantityKitted that has the
same partNumber of the JobNo(new)