I Want New field 'DefectCode' From the field different data

[Sxbbb]

I have  Table ' Production'    have  field  'RejectCode'  , 'WorkOrder'  ,    'QtyCode '  

EX  WorkOrder = A0189050-09-000

'

and  I have  Table ' Scrap '    have  field  'ScrapCode'  , 'WorkOrder'  ,    'QtyScrap '

EX  WorkOrder = A0189050-09-000

But field 'RejectCode'  is   field 'ScrapCode ' + DefectCode field, which is set to extract other 'DefectCode 'data as 'DefectCode' field only.

I Want    New  field  'DefectCode'  

EX  WorkOrder = A0189050-09-000

field 'RejectCode'  is   field 'ScrapCode ' + DefectCode field