{"id":376,"date":"2010-07-06T15:31:37","date_gmt":"2010-07-06T22:31:37","guid":{"rendered":"http:\/\/45.63.48.66\/?p=376"},"modified":"2019-05-02T14:59:36","modified_gmt":"2019-05-02T21:59:36","slug":"table-2000000068-record-link-almost-great","status":"publish","type":"post","link":"https:\/\/gotcal.com\/index.php\/2010\/07\/table-2000000068-record-link-almost-great\/","title":{"rendered":"Table 2000000068: Record Link – almost great!"},"content":{"rendered":"

\"\"Since version 5 of Dynamics NAV there has been the new application wide functionality for Record Links. You know the little paperclip in the toolbar. In Microsoft words: “The Record Links feature in Microsoft Dynamics NAV enables you to link Microsoft Dynamics NAV records to relevant documents such as reports and spreadsheets. For example, you could link documents from Microsoft Office SharePoint Server or on a file server to a sales order or purchase order.<\/em>”
\n<\/p>\n

In earlier versions you were relying on either local customization or using a document management add-on like Matrix Docs. The new standard Dynamics NAV feature could have been a game-stopper for these add-ons, if it wasnt because of some limitations to the way it is implemented in Dynamics NAV. Looking at the Table 2000000068: Record Link, which is a system table, you will notice you can design this table and add code into the misc. triggers on the table for both field validation and RIMD triggers. Great, well not really – as the “form” used is not a real “form”. When you click the paperclip or use the shortcut key Ctrl+L to open the Record Links a form that looks like a real Dynamics NAV form opens up. But try to design it – nothing happens. Also when validating a field or inserting a record, you will notice it does not trigger any of your triggers on the table.<\/p>\n

\"\"
\n<\/span><\/p>\n

The functionality is available from any record in the system (almost). And if you look at codeunit 80 Sales-Post and codeunit 90 Purch.-Post, you will actually notice that the standard functionality actually moves the links from Sales\/Purchase Header to the posted documents.<\/p>\n

Codeunit 80 Samples:<\/p>\n

\nSalesShptHeader.COPYLINKS(Rec);\n...\nReturnRcptHeader.COPYLINKS(Rec);\n...\nIF HASLINKS THEN DELETELINKS;\n<\/pre>\n
Lets take a look at these functions that is available on the record variables. The new functions can be found from the C\/AL Symbols Menu:<\/p>\n
\"\"<\/p>\n
So if you wanted to create your own links form, it would be pretty simple. Unfortunately you would have to modify each and every form where you want the new functionality on, to override the CTRL+L shortcut (and if users still use their mouse to click on the paperclip, it still will go to the standard form).<\/p>\n","protected":false},"excerpt":{"rendered":"
Since version 5 of Dynamics NAV there has been the new application wide functionality for Record Links. You know the little paperclip in the toolbar. In Microsoft words: “The Record Links feature in Microsoft Dynamics NAV enables you to link Microsoft Dynamics NAV records to relevant documents such as reports and spreadsheets. For example, you […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[3],"tags":[77,34,35],"class_list":["post-376","post","type-post","status-publish","format-standard","hentry","category-navision","tag-navision","tag-record-link","tag-system-table"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/gotcal.com\/index.php\/wp-json\/wp\/v2\/posts\/376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gotcal.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gotcal.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gotcal.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gotcal.com\/index.php\/wp-json\/wp\/v2\/comments?post=376"}],"version-history":[{"count":26,"href":"https:\/\/gotcal.com\/index.php\/wp-json\/wp\/v2\/posts\/376\/revisions"}],"predecessor-version":[{"id":1049,"href":"https:\/\/gotcal.com\/index.php\/wp-json\/wp\/v2\/posts\/376\/revisions\/1049"}],"wp:attachment":[{"href":"https:\/\/gotcal.com\/index.php\/wp-json\/wp\/v2\/media?parent=376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gotcal.com\/index.php\/wp-json\/wp\/v2\/categories?post=376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gotcal.com\/index.php\/wp-json\/wp\/v2\/tags?post=376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}