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 into 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
Was this topic helpful? Send feedback.