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 () 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
1.By Autolookup
2. By Method(SysTableLookup)
DataDictionary/Tables/KMAction/actionTypeIdsysTableLookup
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