Help

Adding and viewing data
F
ILEMAKER PRO HELP 100
Related topics
Placing and removing fields on a layout
Printing troubleshooting
Wrong or missing data in field
• In networked databases, global field changes made by a guest are available only to that
guest, and only until the guest closes the file. Each guest can have a different global field
value. If all guests must have the same value, define a calculation field with a constant value
(in quotes).
• A ? in a field means that:
• A field object is too small to display the number, date, or time data in the field. For
information on resizing the field object, see
Resizing and reshaping objects.
• A date or time is invalid. For more information, see Working with data in date fields and
Working with data in time fields.
• If the field uses a value list (list, menu, radio buttons, or checkboxes), the value in the field
might not be visible if it does not match a value in the value list. To see all values a field
holds, place a copy of the field on a layout, but don't format it to use a value list. In Browse
mode, click in the field to see all of its contents, or perform a find for a specific value.
• If the field is a repeating field, make sure it is formatted on the layout to display all repeats.
• In Table View, only the first matching record in a portal is displayed.
• A number field or calculation field could be formatted on the layout to display a limited
number of decimal places. Calculations based on the field use the number the field actually
holds, not the number displayed. See
Formatting and setting up field objects in Layout
mode for more information.
• Use field validation to prevent the wrong data from being entered. For more information, see
Defining field validation.
• Data could have been entered before field validation options were created.
• If the field is supposed to be displaying related data, check to make sure there is a match for
the relationship that would cause related data to appear. For more information, see
About
match fields for relationships.
• Check the alignment of the field in Layout mode. For example, data might be aligned right,
and that end of the field might not be visible on the layout.
Related topics
Finding records troubleshooting
Dates are not as expected
Records are missing
Dates are not as expected
To avoid confusion when entering dates, always use four-digit years.
• Check the date formatting applied to the field. See Specifying formats for date fields.
• Make sure dates are entered into fields of type date. Choose File menu > Manage >
Database, click the Fields tab, and check the field type of the field.
• Use field validation to prevent the wrong dates from being entered. For more information,
see
Defining field validation.