Find out the different records from table

Jacob1227Jacob1227 Posts: 93Member
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

  • KlappspatenKlappspaten Posts: 19Member
    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.
  • Jacob1227Jacob1227 Posts: 93Member
    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.

  • lubostlubost Posts: 551Member
    Be inspired with Item Ledger Entry vs Vale Entry tables
Sign In or Register to comment.