Skip to Content
Feb 07, 2012 at 10:43 AM

Fetching the latest drawing No. after changing Sampling Drawing Procedure


Hi QM Masters,

I have 1 Report in that I fetch Drawing No. against Inspection Lot.

When I create a Inspection Lot at that time Drawing No. will generated in the system. Sampling Drawing procedure is assigned to the Lot. But the problem is that When I change the sampling procedure New Drawing No. is generated against the same lot.

Both Drawing No. are updated in QPRS table against the same lot. That's why It is difficult to fetch the latest Drawing no.

How I fetch the latest drawing no. after changing the SDP?

Gives me the Expert logic to fetch the data.