The Query/Export module allows for a field to be indexed for this purpose.
To index a field: 1. Open the Query/Export parameters being used 2. Select the Output tab 3. Double-click on the field to be indexed 4. Mark the 'Index this field when exporting to MDB format' checkbox 5. Export the query
The field(s) selected are indexed to allow linking outside of Blackbaud products.
NOTE: In order for two databases to be linked together properly the indexed fields must have the same value. For example, if the field Account number is indexed in data file 1 and the account number in data file 2 is indexed, then these two fields can be linked. However, if the account numbers do not match in these two files, then records will not be linked properly.