Join view as a Second / Secondary data source in D365 F&O or AX 2012

 In this post I am going to discuss about how to add View as a Secondary data source in form and use it in the grid.

1. Create a form with table as a Root data source.

2. Create a Grid with this data source.

3. Form view, notice that right now  the invoice number field is a Display method and we are going to get it by using view

4. Create a AOT query and View for that query

add simple query to a view

View 

5. Add View as a Secondary data source

6. Join the view with required data source in this I am joining with VendPackingSlipTransInvoice Data source, you can join with any data source you want

7. Go to the VendPackingSlipTransInvoice data source and override the init method of the datsource

8. Add a link between the fields you want to provide the link.

9. Use datasource