Skip to Content
0
Former Member
Jun 11, 2009 at 07:27 AM

Value should increase by comparing 2 fields.

35 Views

Hi,

I have a requirement,

This is nothing but Material and Serial no Combination. If same material and Serial number get repeats

no of repairs value should increase

For eg,  
 
       Prt no   Material no     Serial no   No of repairs
 
      #A0005    XYZ                ABC          1
      #A0006    XYZ                DCE          1
      #A0007   PQR                ABC          1
      #A0008   XYZ                 ABC          2

By default the repair value will be 1.

I have Material No and Serial no in my final table T_final.

I want to put a condition where it will let us know the if the Materail number is repated with Serial number so that it should add 1 and append the Number of repairs field.

Any suggestions will be appreciated.

Regards,

Kittu

Edited by: Kittu on Jun 11, 2009 9:27 AM