In Microsoft Dynamics NAV, Lookup Form on a field corresponding to a particular selected option of another field can be displayed in the Request page of a report using C/AL code. In this article we are going to see the procedure with the code required to achieve the same.
Tag Archives: Lookup
Dynamics NAV How-To Program Lookups
Often in Dynamics NAV development, you need to do a lookup into a table, find a record, and return it to our original page. There are ways to do this that come with constraints, and other ways that are significantly more robust. This blog will provide a general tutorial for both a simple lookup and a more complex lookup method.
Dynamics NAV Web Client – Filtered look up for Document creation
In Microsoft Dynamics NAV 2013 Windows client, When creating a Document (Sales Order/Quote/Invoice, Purchase Quote/Order/Invoice etc..) Filtered look up works wonderfully.
For example, when creating a new sales order, type few letters of the customer’s name in Sell-to Customer No. field and you will get a filtered list as shown below. This makes choosing a customer very easy in Sales order creation process.
NAV2013 Glance 7: Lookup on Image Property
Finding out that various things have been enhanced in the development environment, I am getting in the “wanting more” mode. Am I getting spoiled already?
Forms and Pages are editable in lookupmode
Some forms and pages in Dynamics NAV are used both for setup and look up. For example form and page “Payment Terms” with ID 4. I like to add a code to forms and pages to prevent this.
Looking Up Temporary Tables
Have you ever tampered around with the OnLookup Trigger to run a lookup to a temporary table?
This is not a very difficult task and looks something like the following;
Coding dependant form lookups
Sometimes it can come in handy to code a lookup on form level. Because the records shown in the lookup form are dependant on the value of another variable.