Link Categories (Magic xpa 2.x)
From a Header row, other than the Top Header row, you can select from the following Link operations:
Link Query – This operation is used to establish a connection to a record in the linked data source. If the link fails (because the record does not exist in the linked data source), no record is displayed.
Link Write – This operation is similar to the Link Query operation. However, in the Link Write operation, if the linked record does not exist, Magic xpa will attempt to create a new record in the linked data source.
Link Create – This operation does not attempt to establish a connection to a record in the linked data source, but always creates a new record in the linked data source. If the indexed record exists, you may receive errors if the indexes are unique.
Link Inner Join – Used for SQL databases. The program's data view includes only records that have an existing linked record in the linked data source.
Link Left Outer Join – Used for SQL databases. This operation behaves the same as the Link Query operation; however, the preparation of the data view is different. The program's data view includes all the Main Source records, regardless if a linked record exists in the linked data source.
End Link – Closes the link opened by its counterpart Link operation.
Link Properties
Link Order
Link Criteria
Recomputing Link Expressions
