Download Mosaic Training Manual

Database Designer
Defining Fields
To create a database layout, you must define each field by naming it and specifying the
field’s type and size. This is done in the Database Layout Window, shown below.
To make creation of the layout easier, the following functions are available for certain
field types.
•
•
•
•
•
define validity check for individual fields.
define lookup tables for individual fields
establish an applicant name link used in the ‘Capture’ application for clarity when
viewing records.
Designate a field as a secondary sort.
Special processing.
8