Creating Lookups in form

 

Creating Lookups on forms.

There are three methods with which you can create lookups on a form. Today we will discuss all those three methods.

METHOD 1:

Through Field Properties.

Add a string control on a form. Go to the properties and alter them as shown.




 

 

METHOD 2:

Through overriding lookup method.

Add a string control on the form. Exapand the control node, right click the method option and override the lookup method. It opens the xpp file with basic structure. Write the given code code and click save. Debug and open the project to see the desired lookup.



 


 

 

METHOD 3:

Through table auto lookup property.

Go the datasource table of the form. Expand the field group node. Drag the desired fields from Fields node to AutoLookup node.


Save it then go back to the form.

Drag the autolookup node from datasource to design pattern. It creates a group by default and add the fields automatically.



Save and build the project to get the desired result.






 

 

Comments

Post a Comment

Popular posts from this blog

How to customize segmented entry control

Image
 Customizing Segmented entry Lookup in out of the box form When you have a requirement to customize the lookup in ledger dimension segmented entry, following are the steps needed to perform to achieve this requirement. Step 1: Create field account type that contains multiple accounts like Customer, Vendor, Bank etc. Create field account number that will save the account number related to account type selected. for account number take EDT ledger dimension that would save the RecId of account number. Step 2:  Now paste your field along with account type in extension of out of the box form. And set the following properties of segmented control with auto declaration set to yes. Step 3:  Create a class to extend from dimension hierarchy class. Step 4:  Create condition based on your account type. Step 5:  Create extension class of SegmentedEntryControl class. Step 6:  Override the checkUseCutomLookup method. and specify for what account types custom lookup is re...
Read more

Integration from azure blob through x++

Image
IMPORT INTEGRATION FROM AZURE BLOB THROUGH X++   This document will contain all the steps needed to fetch file(s) from azure blob storage account container and process the data as per requirement. Azure Blob Storage is Microsoft's object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data. Blob storage is designed for: ·        Serving images or documents directly to a browser. ·        Storing files for distributed access. ·        Streaming video and audio. ·        Writing to log files. ·        Storing data for backup and restore, disaster recovery, and archiving. ·        Storing data for analysis by an on-premises or Azure-hosted service.   Here is how to configure storage accounts: Step# 01: Navigate to URL: https...
Read more

Change tracking through AIFChangeTrackingTable in X++

Image
  Change tracking through AIFChangeTrackingTable in x++   This document demonstrates how to get changes done in tables through data entity. You need changed records from multiple tables and save those records in our custom table. For this, you need to create a data entity containing the tables, views or query to include required tables. Then, Navigate to Modules -> System Administration -> Data Management. Click on Data Entities Search for your entity . Then click the three dots on action pane and select Change tracking . It will show three options, select enable custom query . After selecting the option, you will get these Infolog messages and change tracking will be changed to custom. This is needed to functionally enable the change tracking for required entity. The requirement is to get the  records that are created or modified in actual tables. For this you have to create a query same as data entity and with calling AIF change tracking ...
Read more