Automatic field values changed according to master table field modified In Axapta

Question

Hello All, I am New to axapta. I have two table WI_MachineDrawing and BOM. There is two common filed call RevNo and WI_MachineDrawngNumber. Now i wan to do something when i alter Wi_MachineDrwawng filed RevNo then BOM RevNo should be modified according to WI_MachineDrawing RevNo field. Please give me solution.

Please help as soon as posible. its Urgent. Thanks

Answer 1

Override the modifiedField method on the table WI_MachineDrawing to update the field in BOM when RevNo changes:

public void modifiedField(fieldId _fieldId)
{
    BOM BOM;
    ;
    super(_fieldId);
    switch(_fieldId)
    {
        case fieldnum(WI_MachineDrawing, RevNo):
            update_recordset BOM 
                setting RevNo = this.RevNo
                where BOM.WI_MachineDrawingNumber = this.WI_MachineDrawingNumber;
            break;
    }
}