Need help data transfer b/w table in nav 2009r2..

Business Central/NAV Technical Forum
1

Dear Friends,

i have one common field in sales header and sale line table.

Field = Order Status (option)

Requirement : This field need to synchronize b/w above two tables. suppose while i am change the status in header then the same changes need to be done in line table automatically.

Can any one please help me with the sample code.

2

hi,

at the end of the Order Status OnValidate Trigger in table Sales Header:

//create new local variable SalesLine | record | Sales Line

SalesLine.setrange(“Document Type”,“Document Type”);
SalesLine.setrange(“Document No.”,“Document No.”);
if SalesLine.findset(true,false) then
repeat
SalesLine.“Order Status” := “Order Status”;
SalesLine.modify;
until SalesLine.next = 0;

3

Hi jonathan,

Thank you so much for your reply.