About Append Queries

An Append query adds a group of records from one or more families to another family.

An Append query lets you:

Use a predefined Select query to find records in one or more families that you want to add to another family.
Take the records that are returned and add them to other families, thereby creating new records in those families.

For example, you might create a set of records in one family that are the same or similar to a set of records that you also need to create in another family. You can also consolidate records that currently exist in multiple families into a single family. In either of these cases, you can use an Append query to find the records that currently exist in one family and add them to another family. In cases where you are using an Append query to move records, you might also want to use a Delete query to delete the records from the original family after they have been moved.

In an Append query, you will define field mappings to map fields in the source family to fields in the target family. Only fields that are included in the Select query can be mapped to the target family, so you will want to make sure that the query includes all the columns containing values that you want to use to populate new records. Any fields that are not mapped will not be populated in the new records. The process of defining mappings is facilitated by the Append To cell, which appears in the grid in the Conditions section when you create an Append query, and which allows you to select the target field to which each source field corresponds.

Only Super Users and members of the MI Power User Role Security Group can create Append queries. All users can run Append queries, provided that they have been granted permission to access the Catalog folder in which they are stored. To create the records returned by the query, a user must have Insert permissions to the family in which the records are being created.