Creating a lookup dynamically

Automatic lookups, mentioned in the previous recipe, are widely used across the system, and are very useful in simple scenarios. When it comes to showing different fields from different data sources, applying various static or dynamic filters, or similar, some coding is required. Dynamics AX is flexible enough that the developer can create custom lookups, either using AOT forms, or by running them dynamically from the X++ code.

This recipe will show how to dynamically build a runtime lookup from the code. In this demonstration, we will modify the Vendor account lookup on the Customers form to allow users to select only those vendors that use the same currency as the currently selected customer.

How to do it...

1. 1. Open the VendTable table in the AOT, and create a new method:

   public static void lookupVendorByCurrency(
   FormControl _callingControl,
   CurrencyCode _currency)
   {
   Query query;
   QueryBuildDataSource qbds;
   QueryBuildRange qbr;
   SysTableLookup lookup;
   query...