To add a new field into the custom table click on this link.
This Define Fields form comes forward when you are adding or editing field.
Field Name
The display name used in the interface Alias
The name in the SQL database ( This can not be changed )
Allow Blank
Allow the user to leave the field empty.
Generate History
Create a history record when this field changes.
Primary Field
Is this a primary field.
Use drop-down list
Is there a drop down list the users can select from when doing data entry.
Default value ( Auto Fill or Auto Populate )
The default value can be any text string or the default value can be automatically filled/populated from the parent record. Below we are populating the field using the value from the Contact's ID/Status field.
If you want to display the Contacts ID/Status field on the data-entry form without creating a field in the child table please read see Add contact field onto the form
Field Format
The format string used to format the data entry pattern such as phone numbers.
Field Length
The maximum length of characters which can be entered into this field. In the old DOS/DBF days you always tried to make this the smallest number possible. In today's SQL driven data back ends it is not as critical to performance.
Email This Article
Previous Article
Next Article