Tuesday, July 29, 2014

Lookup Ways in Ax 2009

Lookup:  A lookup form is a small form that you use to select a value for a control. To open a lookup form, click the lookup button (Lookup button) that appears with the control. To select a value, double-click the record that you want to appear in the control.

1.By Autolookup


 2. By Method(SysTableLookup)
     DataDictionary/Tables/KMAction/actionTypeIdsysTableLookup
     


 create a lookup form to a control
    http://msdn.microsoft.com/EN-US/library/hh185372.aspx

3.  By EDT


  in AX-2012

1. First create New EDT.

2.Create New Table Name is "TestParent" Table, then drag and drop the newly created EDT in "TestParent" Table

3.Create Index for new created EDT in "TestParent" Table , the properties on index is AllowDuplicates to No and Alternativekey to Yes.

4. Then select the "TestParent" Table and right click on it select properties sheet set the "PrimaryIndex" property i.e. the newly created index.

5. Then go to EDT and right click on it, select property sheet then go to "ReferenceTable" property set it to "TestParent" Table Name.

6. Create a Second Table i.e “ChildTable”.

 7. Then Drag and drop the EDT, then it will prompt the one dialog box, in that dialog box click Yes button then lookup will created on that field.


4. By TitleField1 and TitleField2

5. By Relations

No comments:

Post a Comment

Enable/Disable form control based on multiple rows select

 class PurchTableFormEventHandler {      [FormDataSourceEventHandler(formDataSourceStr(PurchTable, PurchTable), FormDataSourceEventType::Act...