Find out the different records from table

Jacob1227
Jacob1227 Member Posts: 128
in NAV Three Tier
Hi all,

How to identify the different records from one table?

Ex: I have a table 'posted records' .This table has parent and child records. For one doc no, the combination is a parent with Children, for another doc no ,it only has children

Can you please suggest me some steps to retrieve "Parent with Child data" records and the "Only child data" records separately.

Thanks in advance,
Jacob.A

Answers

  • Klappspaten
    Klappspaten Member Posts: 22
    Hey,

    your given example is not that insightful, but for me it seems like you try to link the information 'record is parent/child' to a Document No. which is not a good idea since Document Nos. change with each posting.

    Could you please give a more specific example? Thanks.
  • Jacob1227
    Jacob1227 Member Posts: 128
    Hi Klappspaten,

    Thanks for your response.

    Please see this attached image.

    8qyby7jhd4x5.png

    All of them have the same doc no. From here I want to get the 'parent with its own child' and 'another child data' separately

    Guide me, please.

  • lubost
    lubost Member Posts: 633
    Be inspired with Item Ledger Entry vs Vale Entry tables

Categories