Getting data of subform in main form.

upasanisandip

Hi everybody,

I took one new command button in sales order header form. i.e. form no. 42 & I want the description of sales-detail table when i press that command button.
Any solution if anyone have , pl. let me know.


Thanks
bye .

Sandip.

Marije_Brummel

You can get the information of the salesline by programming code.

What do you want to do with the information one you have got it from the lines?

Savatage

upasanisandip wrote:

sales-detail table

:?:

upasanisandip

yes, but what is that code i have to write in sales line or header form.
Basically i want the quantity of item from sales line table when i press that new command button.

upasanisandip

sales-line table

sgg

Since you may have more than 1 record in the sales line, you could create a new field (Flow Field) on the sales Header that Sums up the Quantity filed on the correcponding sales lines the same way you have the Amount filed on the sales header summing up the amount on the sales line.

Then you call the Calcfields Function when you press you button to get the sum of the Quantity.