Link tables in one

edo906
Member Posts: 7
Hi,
I have a project for Nav 2013r2 and Nav2018
I have a table with many fields(photo)

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
I have a project for Nav 2013r2 and Nav2018
I have a table with many fields(photo)

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
0
Answers
-
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
0 -
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,
Chris0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions