Multiple table fields custom lookup in AX 2012
Hi Friends, Today, in this post we are going to share how you can add multiple tables fields custom lookup in AX 2012. Let's take a scenario to understand the requirement first... We need to make custom lookup for Product Number from EcoResProduct table and Item Number from Invent Table. For this type of requirement first create a query by joining these two tables and then add query and fields in view. Steps to follow: 1. Create a new query and drag and drop InventTable from AOT in it. 2. Set the fields property Dynamic = No and add ItemId in fields. 3. In InventTable data source drag and drop EcoResProduct table from AOT. 4. Set the fields property Dynamic = No and add DisplayProductNumber in it. 5. Set the Fetch mode = 1:1 and Relations = Yes for EcoResProduct data source property. 6. Query is ready to use to add in View. Let's create a view. 7. Create a view and add your query in it. 8. Add fields which you want to show in the view. 9. Write cu...