When you define a field, you select a
field type based on the kind of information the field will contain. The field type determines what kind of data can be entered and what kinds of operations FileMaker Pro can perform with the data.
FileMaker Pro uses the field type to interpret the data for tasks like sorting records and performing calculations. For example, if you create a text field and enter numbers, you can sort the data only in alphabetical order. (The first character sorts, then the second, so that 11 sorts before 2.) You must use a number field, or a calculation or summary field with a numeric result, to sort data in numerical order.
You select the field type in the Fields tab of the Manage Database dialog box. To select the field type in Table View, right-click the column heading, choose
Field >
Field Type > and select one of the options for
Field Type.
|
|
|
Up to approximately 2 GB of letters, symbols, and/or numbers used as text per field repetition, limited by available RAM and disk space. Indexes nominally based on the first 100 characters of each word or value. Text fields may contain carriage returns.
|
|
|
|
|
|
|
|
|
|
A file of any type, such as a picture, a PDF, or a multimedia file. You can set up storage and display options for the field. You can reference container fields in calculations and summary fields. You can't find or sort records based on container fields, but you can define text fields to describe or identify them. Then, you can find or sort records based on the description or identifying number in the text field. Files in container fields can be embedded, stored as a reference, or stored externally.
|
|
|
|
|