Combining 2 different table into a single staging table

Mathan
Mathan Member Posts: 55
edited 2017-03-28 in NAV Three Tier
Hi everyone,

I am looking for a way to combine Warehouse Shipment Header 7320 and Warehouse Shipment line 7321 table into a single staging table, I have tried it to create manually, but no success because of the repeating fields. Can someone help me on what should be done to make it into one single staging table?

Thanks in advance :smile:

Best Answer

Answers

  • Mathan
    Mathan Member Posts: 55
    Thank you for the reply HannesHolst.
    since the single shipment has multiple lines, This won't mess up anything right?
  • HannesHolst
    HannesHolst Member Posts: 119
    Mathan,

    When thinking in Table-relations, of course, you would have something like this:
    jadeimiyjp65.png

    The green columns are coming from the Lines and the blue from the Header.
    My blog - https://www.HannesHolst.com/
  • Mathan
    Mathan Member Posts: 55
    Thank you,

    so there is no need to delete the repeating fields which are in sales header while adding it?
    For example the No. field over there in your example.
  • HannesHolst
    HannesHolst Member Posts: 119
    I would in either case create a new table from scratch. Modifying an existing table this way will lead to problems caused by errors in objects which are rely on. For example Pages, Codeunit and Reports.
    My blog - https://www.HannesHolst.com/
  • Mathan
    Mathan Member Posts: 55
    Thanks for the answer and heads up :smile:

Categories