Steps to Creating a view in axapta
1. First, we locate the Views node under the Data Dictionary in the AOT.
2. Right-click on the Views node and select New View. A new view will be created. You can open its properties by right-clicking and selecting Properties.
3. Change the name of the view to firstCust second and give it a label that describes the contents of the view.
4. The views can actually use queries that have already been created as a base for the data selection. This is done in the Properties of the view by choosing the query from the Query property. However, in our example, we will create the view from scratch.
5. Under the Metadata node, right-click on the Data Sources node and select New Data Source
6. Select the newly created data source and enter firstTable in the table property. The name of the data source will automatically change to firstTable_1, which is normal.
7. Under the firstTable data source, find the Data Sources node, right-click on it, and select New Data Source. This time, we want to use the secondTable so change the table property to secondTable. Also change the relations property to Yes in order to get the link between the two tables active in the view.
8. Do the same to add the CustTable as a child data source to the secondTable.This.
9. The next step is to define the fields that should be made available when this query is executed. Simply drag fields you need to use in the view from the firstTable_1, secondTable_1, and CustTable_1 data source and drop them onto the Fields node.
1. First, we locate the Views node under the Data Dictionary in the AOT.
2. Right-click on the Views node and select New View. A new view will be created. You can open its properties by right-clicking and selecting Properties.
3. Change the name of the view to firstCust second and give it a label that describes the contents of the view.
4. The views can actually use queries that have already been created as a base for the data selection. This is done in the Properties of the view by choosing the query from the Query property. However, in our example, we will create the view from scratch.
5. Under the Metadata node, right-click on the Data Sources node and select New Data Source
6. Select the newly created data source and enter firstTable in the table property. The name of the data source will automatically change to firstTable_1, which is normal.
7. Under the firstTable data source, find the Data Sources node, right-click on it, and select New Data Source. This time, we want to use the secondTable so change the table property to secondTable. Also change the relations property to Yes in order to get the link between the two tables active in the view.
8. Do the same to add the CustTable as a child data source to the secondTable.This.
9. The next step is to define the fields that should be made available when this query is executed. Simply drag fields you need to use in the view from the firstTable_1, secondTable_1, and CustTable_1 data source and drop them onto the Fields node.