Attributes of Fields on Default Forms
Vision assigns attributes to fields on the default form as follows:
• You cannot display the join field in the Detail table.
• Any field in the Master or Detail table that activates a Lookup table is created as a mandatory field (that is, the user must make an entry in this field).
• Lookup table columns that you display as fields on the form are:
– Query-only for simple fields
– Display-only for table fields
• Sequenced fields in Append frames are created as query-only.
• Columns in a Master or Detail table that are not null not default are created as mandatory fields.
• All Master and Detail table columns that you include in the visual query are created as restricted fields; that is, you cannot:
– Change the field's internal name
– Change the field's data type
– Delete the field from the form
The default form can change when you modify the frame definition. You can also use Vision's forms editor to modify a Vision-generated form. For more information on using the Vision forms editor, see
Editing a Form.