About Table Definition
Use the Table Definition form to create and maintain tables to store data collected in modeled forms.
A table can be connected to multiple forms, and multiple tables can be connected to a single form. It is best practice to have one form per envelope, and one or more tables per envelope. This allows you to gather all required data while keeping table columns to 75 or less. You can add more than one form to an envelope, but you must ensure all form and table modifications are complete for both forms prior to import. If you do not, you risk overwriting prior forms with incomplete modifications. There is no way to import a partial envelope.
Please note:
If any of the following items are changed, reports based on the table must be updated:
- Table Name
- Column name of sort date
- Binary storage table name
- Column name
The following fields can be changed if they do not contain data:
- Does Dictionary Map To A Different Entity
- Entity Database
- Dictionary
SQL format uses an underscore (_) to separate words in SQL table names. See SQL Reserved Words for a list of words that cannot be used in SQL table names.
- ► See Also