Versions Compared

Version Old Version 7 New Version 8
Changes made by

admin

admin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

When creating a sub-type entity, the system uses this attribute to link to the parent entity's ID field on the ParentID field of the sub-type. It can also be used for second-level sub-types to link back to the top-level entity. See the PersonID field in the PersonCompanyFunctions sub-type entity for an example. See Multiple Filegroups for more information on sub-type entities. Finally, it is also used in some instances for top-level entities; see the OrderMeetingDetail top-level entity for an example.

Anchor
_info
_info
Info Tab

The Info tab within the Fields record stores the field's description and the field's online help settings.

...

  • When set to None, Aptify adds this field to a generated form as a standard multi-line text field. See Multi-Line Text Field for more information.
  • When set to RTF, Aptify adds this field to a generated form as a Rich Text Field part. See Rich Text Field for more information.
  • When set to HTML, Aptify adds this field to a generated form as an HTML Field part. See HTML Text Field for more information.

Anchor
_security
_security
Security Tab

This tab configures the field's security settings. Field Level Encryption setting appears by default. Additional options and tabs appear when Field Level Security is enabled at the entity level. See Field Level Security for details.

...

All User permissions for the field are defined on this sub-tab.

Anchor
_validation
_validation
Validation Tab

An administrator can configure the field's validation settings on this tab.

...

  • Static List: When this option is selected, an administrator manually enters one or more values in the Values sub-type list (by creating a Values record for each value; see Values Form). Also, see Standard Combo Drop-down List.
  • SQL Statement: When this option is selected, an administrator enters a SQL Statement in the Values field of a Values record (see Values Form) to define the list of records and the associated fields that appear in the selection list (both in a data combo drop-down field on a form and in a multiple selection dialog, depending on the configuration of the GUI Type Single Select and GUI Type Multi Select options). When selecting this option, you may also need to specify the Linked Entity and Linked Field in the Fields record's Top Area. See Data Combo Drop-down List.
  • Entity List: An entity list is a register of values that originates from a list populated with values from another entity. If this option is selected, all of the information within the Entity Link display information section of the associated Values records must be populated (see Values Form).

Anchor
_virtualField
_virtualField
Virtual Field Tab

A Virtual Field tab appears on the Fields form when the In Table option is cleared. This tab allows the administrator to define how the virtual field is derived from the database.

...

Note

If you are adding a Computed field to an entity that has multiple base tables, the Computed field and all of the fields that are referenced in its calculation must be in the entity's primary base table. Refer to Microsoft SQL Server Books Online (https://technet.microsoft.com/en-us/library/ms130214(v=sql.105).aspx) for more information on Computed Columns and their requirements.

...