You may create any number of catalogs and up to 248 fields on each catalog.
The actual limit for data fields you may create depends on your selection of data types.
Certain data types allocate 2 fields from the limit each.
When you create one of the following field types, the remaining number of fields you may create decreases by 2 instead of 1.
- Relationship field: A relational lookup field which shows data from parent record. Only the catalog showing
the lookup field is affected.
- Computed fields which retrieve and display data from parent record.
These are the computed fields for which the task is set as "Copy data from parent record".
- File fields.
Tip: You may check the number of currently allocated/remaining fields from the field list window.
Right click the desired catalog, select "Fields". The information is displayed at the bottom of the field list window.
In majority of applications there are relatively fewer number of these type of fields and the maximum number of fields you may create is well above 200.
If your application requires significant number of these type of fields, you may calculate the actual maximum fields you may create
as shown in this example:
3 text field spend 3
5 expression type computed fields spend 5
3 relational type computed fields showing parent data spends (double each) 6
2 file/image field spend (double each) 4
Total fields allocated: 18
The remaining number of fields you may create: 248 - 18 = 230