CODEWITHSUNDEEP
axapta
Bhavin Sankhat
Bhavin Sankhat

Reputation: 1

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

I have two table WI_MachineDrawing and BOM. There is two common filed call RevNo and WI_MachineDrawngNumber. Now I want to do something when i alter Wi_MachineDrwawng filed RevNo then BOM RevNo should be modified according to WI_MachineDrawing RevNo field.

Upvotes: 0

Views: 1706

Answers (1)

Jay Hofacker
Jay Hofacker

Reputation: 3469

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;
    }
}

Upvotes: 1

Related Questions