Help

Adding and viewing data
F
ILEMAKER PRO HELP 99
• In FileMaker Pro 10, there was a change to how FileMaker Pro performs the Replace Field
Contents and Relookup Field Contents commands and script steps. Replace/relookup
operations are now performed without committing the active record. This change only
affects multiple uncommitted records in a window transaction, as when you do a replace/
relookup on related records in a portal. If there are uncommitted records in the window that
are affected by the operation, these changes will be made using the window's transaction
and remain uncommitted until you choose to commit the changes following the completion
of the operation. All other records will be modified and committed during the operation as
before. For more information about committing data, see
Committing data in records.
Important To avoid confusion when replacing dates in FileMaker Pro, always enter dates with four-
digit years. For more information, see Conversion of dates with two-digit years.
Related topics
Entering and changing data in fields
Finding records
Adding and viewing data troubleshooting
Saving and copying files
Adding and viewing data troubleshooting
If you're having trouble adding or viewing data, review the tips in one or more of the following
sections.
Records are missing
Records are “lost”
• Make sure that any FileMaker Pro file shared over a network has a unique filename,
whether open or not. Use an archiving or compression utility to make all copies of your files
unavailable to FileMaker
Pro, or store them on removable media and remove the medium.
• You might have entered the records in Find mode. In Browse mode, in the status toolbar,
click the down arrow next to Find (Windows), or click and hold Find (OS X). Choose Modify
Last Find and see if the “lost” records appear. If so, you can:
• Flip back and forth between Modify Last Find and Browse mode and copy and paste
the contents of each field, or
• For one “record”: exit all fields, choose Edit menu > Copy, then paste into an
application like Notepad or TextEdit. (To copy multiple “records”, press Shift (Windows)
or Option (OS
X) while choosing Edit menu > Copy.) Then import this text document
into your database. (Note that this will not work for data entered into related fields.)
• Manually re-enter the records in Browse mode.
Only one record appears in a list
• Check the found set. (Look in the status toolbar.)
• Check the layout in Layout mode. If the top boundary of a field object is touching the line
that separates layout parts, FileMaker Pro displays and prints that field in the layout part
above the line. Thus, for example, fields which appear to be in the body part and which you
would expect to print a number of times down the page will appear only once at the top of
the page if they are touching the header line.