Creating a solution > Defining database fields > Defining fields in the Manage Database dialog box
Defining fields in the Manage Database dialog box
1. Choose File menu > Manage > Database.
2. Click the Fields tab.
3. If needed, choose the appropriate table from the Table list.
Change definitions of related fields in the related table or file.
4. Add, change, or delete fields.
Do this
Add a field
For Field Name, type a name for the field. For Type, choose a field type. Then click Create. To set options for validation, auto entry, and storage for the field, click Options. See Setting options for fields.
Change a field’s name
Select the field. For Field Name, type or paste the new name, then click Change. See About naming fields.
Change the field type
Select the field. For Type, select a new field type, then click Change. See About choosing a field type.
Change field options
Double-click the field name, or select the field and click Options.
Delete a field
Select the field, then click Delete.
Create or change a calculation formula
Select the calculation field, then click Options. In the Specify Calculation dialog box, make your changes, then click OK. See Defining calculation fields.
Create or change a summary field
Select the summary field, then click Options (or double-click the field name). In the Options for Summary Field dialog box, make your changes, then click Done. See Defining summary fields.
5. Click OK.
If you changed the calculation formula or summary calculation, FileMaker Pro recalculates the values when you close the Manage Database dialog box.
To have fields that you define automatically placed on a layout, select the Add newly defined fields to current layout preference (in the Preferences dialog box) before you define the fields. See Setting layout preferences.
To change the order in which fields appear in the Manage Database dialog box (and all dialog boxes that list fields), drag the double arrow Double arrow icon next to the field definition up or down. To reorder by field name or type, click the Field Name or Type column heading.
Related topics 
Adding and changing field labels
Effects of changing field types
Defining fields in Table View
Working with related tables and files
Working with formulas and functions
Using a reserved word or symbol for a field or table name
Copying and pasting field schemas (FileMaker Pro Advanced)