In a multiple database environment, be aware of the following options:
- When creating a calculation or series, you have the option to make the calculation or the series available to all databases. If you do not select this option, the calculation or series will not be available when running Automatic Field Calculations in another database.
- If a calculation is not available in the current database and you want to change this, go to Options>Multiple databases and you'll be able to see all the calculations and series you created, no matter the database and to change their scope.
- When assigning a calculation or series to a field, you have the option to make the assignment available to all databases. If you do not select this option, the assignment will not be available when running Automatic Field Calculations in another database.
Important note
Even though only the "display" names of your fields appear in the syntax editor, Automatic Field Calculations actually stores the internal name of the field.
For instance, you might have a field called "Sales Representative" (its display name) but the real name stored by AFC is "TBL_CONTACT.SALESREPRESENTATIVE_0129844".
The internal field name is assigned to your field at creation time and cannot be controlled, nor modified.
This is a key notion to remember when making a calculation available to multiple databases. Even though your databases might all have a "Sales Representative" field, the calculation will work only if these fields have the same internal name.
Two databases have similar internal field names only:
- for the standard fields that ACT! automatically creates when you create a database;
- for all fields that are inherited from the other database (Ex: a satellite database that you create to synchronize will inherit the same field names as its master database. Same when you create an empty copy of a database);