update form

nt

hi all

i got a flowfield in the primary form based on the lines of the subform.
how i can update the flowfield in the primary form when i change the line in the subform?

thanks.

Marije_Brummel

Have you searched the forum for this.

http://www.mibuso.com/forum/viewtopic.p ... +flowfield

http://www.mibuso.com/forum/viewtopic.p ... rm+subform

nt

thanks mark, there is another way without using ontimer trigger?

Marije_Brummel

I am trying to avoid this so I have not been confronted with this problem for a while.

You can try to move the flowfield from the header to the line table and put it on the subform.

You can make a flowfield on the line table looking at the line table where the document number is the same.

ara3n

Add a button that the user can click on to refresh.

Onpush trigger add
Currform.updae(false).

Marije_Brummel

Yes, that is also a posibility

bab

You can declare a variable in the subform MyRec: type record, based on the header table, than add a textbox with the SourceExpression MyRec.FlowFieldName.
In the OnAfterGetCurrRecord trigger of the SubForm You can do MyRec.GET(Key), MyRec.CALCFIELDS(FlowFieldName)

DenSter

With the cursor in the main part of the form:
Page up
Page Down

nt

thanks for all your help.
i think it's not possible without the ontimer trigger

girish.joshi

This is a classic Navision problem. I'm guessing that in the header you have a "total" field --- for quantity, weight, something like that.

Another approach is to not use a subform at all.

Just create a form with a tablebox, and have the table box display the lines you want.

For the header information, display those in custom created textboxes and labels.

David_Cox

Like Mark I have done this by cheating, I created a flowfield on the Sales lines before, then resized the Datagrid in the sub form, placed on my flowfields underneath, and it looks as though they are on the main form, cannot even see the join.