Hi all,
I want to insert values in 1 more table based on po header and po line table how to do that when line table contains more than 1 record.
Regards
Nishtha
You must insert from the lines with a reference to the header.
Are you doing this from a report?
If not, please give a little more detail to enable us to help you.
Cheers,
Colin
Sounds like you want your other table to reference the purchase header and line.
In your second table, you need fields Document Type, Document No., and Line No. They should match exactly to the fields in the Purchase Line table. In base NAV, a Line No. of 0 (zero) refers to the header, where as other line numbers refer to the lines on documents.