Articles
Data Models
A data model consists of queries that connect to various data sources. There are several query types.
Define a Data Model Table Query
Learn how to define the properties of the table query you are adding to a form's data model.
Define a File Query
A file query copies data from a file, which you can use as a data model. Supported file types are CSV, Open XML, and XML.
Define a Data Model Lookup Table Query
Learn how to define a data model lookup table query.
Define a Data Model Stored Procedure Query
You can define the data model with a query whose data is retrieved from a stored procedure. This data can then be used to populate a combo box in a form.
Define a Data Model Service Query
You can define the data model with a query whose data is retrieved from a service. This data can then be used to populate a combo box in a form.
Define the Association Between Queries
The association between the objects is established in the query itself.
Add a Data Source to Data Model
Learn how to bind a data source to a form by selecting it from a list of queries that were defined in the data model.