To merge (add) or "unmerge" (mass-delete) records from other databases, use the Tools > Merge/Unmerge command. The displayed dialog box enables you to specify how adding or removing records should be carried out:

Option 1, "Add all records from the specified table", unconditionally adds all records from the external table and performs field name matching in the current and the merged tables to assign imported values to the correct fields. You can bypass this matching requirement by using this command in the form of a script - please see the examples in the Scripting section of this documentation.

Options 2 to 4 cause adding records, updating records, or deleting records in the current table where the specified field values match in both tables.

Note: to perform mass-merging of tables from a given folder or multiple folders, use a script as shown in the "Merging" scripting examples further in this manual.