Link tables in one

edo906
edo906 Member Posts: 7
in NAV Three Tier
Hi,

I have a project for Nav 2013r2 and Nav2018

I have a table with many fields(photo)


tbtt5bxu3ozk.png


I must to create a process(batch) that take value from other table and insert in this( for example id_customer = Sales Shipment Header"."Sell-to Customer No." and other field from another table and so and so)

Many fields are from Sales shipment header and sales shipment line...

How i can link all these table??

Thanks so much and sorry for my bad english





Answers

  • jesperkenborg
    jesperkenborg Member Posts: 9
    To solve this, you can use Linked Tables.

    That way you can make a table in e.g. NAV 2018 that can view/read any table in NAV 2013 (or any other SQL table), and that way you can process the data as you wish between the versions.

    I recall feature has been since NAV 3.6/3.7, maybe even earlier version.

    You can find a post about it for NAV 2013 here: https://dynamics.is/?p=1918

  • Me_Ontour
    Me_Ontour Member Posts: 11
    Hi edo,

    in NAV 2018 you can build a Query object with the nessecary Tables an Fields.

    in NAV 2013 there are no Query Objects.
    Therfore you have to collect your Data (Report with DataItems) or
    build a SQL View and Use it as an LinkedObject

    Cheers,

    Chris

Categories