First, we will create a simple view of service orders, which we will start as a query. To do this, follow these steps:
- Create a new query named ConVMSVehicleServiceDetailView.
This query will be used to create a view. Since this query will control the structure of our view, we want it to be obvious that this query is written as the basis for a view. If another developer made a change to the query and used it for their own purpose, it would affect the view or views that use it.
- Drag the ConVMSVehicleTable table onto the Data Sources node of the new query.
- On the property sheet for the new ConVMSVehicleTable data source, change the Dynamics Fields property to Yes and then set it to No.
Choosing yes will populate the field ...
