In the example below, the fictitious table 70000 Customer Something has a 1:n relationship with the Customer table. It could contain customer addresses, customer contacts or something like that; the most important thing about it is its table relation with the Customer table. The Code field that’s also part of its primary key serves as a differentiator, thus allowing more than one record per Customer.
Issue: In NAV 2009, when attempting to post a Purchase Invoice linked to a Job, you may experience the following error message:
Today, I wanted to talk to you about a very common category of table relation mistakes.
An example
In the example below, the fictitious table 70000 Customer Something has a 1:n relationship with the Customer table. It could contain customer addresses, customer contacts or something like that; the most important thing about it is its table relation with the Customer table.
In summary: This query shows a list of all tables and indexes in a SQL database to help identifying in which tables the most blocks happen, and to give a starting point for index tuning. For further details, refer to the original blog post.
Did you ever had to outline information on a report? For example, the user asks you to move this field a little to the left or right, or can that textbox be a little bigger because sometimes it’s just not big enough?
So, how do you search for a field in table designer? Apparently, it is a feature that everybody is waiting for… but there is a trick that could help you!
In this blog you will find attached a very simple usage of .NET interoperability with Dynamics NAV 2009 R2 with the objective of basic file management (move, copy, open, delete) WITHOUT using the FILE virtual table and is intended just to familiarize with this brand new feature proposed with NAV 2009 R2 release.
Vertalen
