DataItemLink Property (Query)
Version: Available from runtime version 1.0.
Sets a reference between one or more fields of the data item table and data item or data items above it.
- Query data items
Fieldis the name of the field in the table of the lower data item.
Tableis the name of the table of the upper data item.
ReferenceFieldis the name of the field in the table of the upper data item.
You can link to more than one column. Separate multiple column links with a comma.
The DataItemLink property works together with the SqlJoinType property to combine records from tables into a dataset. The DataItemLink property sets up an "equal to" (=) comparison between two fields of the data item tables. When the query is run, the query compares each row of the two data items to find records that having matching values for the fields. Records that have a matching field values are combined into a row in the resulting dataset. In some cases, there will be records that do not have matching values. Set the SQLJoinType Property to include records that do not have matching values. When setting up a data item link between two data items, you always set up the DataItemLink property on the lower data item in the query object.
If the SQLJoinType Property is set to
Cross Join, then you cannot set the DataItemLink property. For more information, see Linking and Joining Data Items to Define the Query Dataset.
A Salesperson table and a Sales Header table have the Code column and Salesperson_Code field in common, respectively. To create a link between these two tables, you add the following value in the DataItemLink property of the Sales Header data item.
DataItemLink = "Salesperson Code" = Salesperson.Code