Contents FileMaker Pro 12 Help Using FileMaker Pro FileMaker Pro basics New features in FileMaker Pro 12 Using FileMaker Quick Start to learn more about FileMaker Pro Converting the trial version to the full version of FileMaker Pro About FileMaker Pro databases About FileMaker Pro modes Performing menu commands Using the status toolbar Using shortcut menus Converting files from FileMaker Pro 11 and earlier Conversion overview Converting a single file Converting multiple files at once Reading the Conversion.log file Converting FileMaker Pro databases earlier than version 7.x Troubleshooting conversion problems Preserving user dictionary information How layouts are converted Layout mode changes and improvements Saving OLE objects in their original formats (Windows) Managing files Starting FileMaker Pro Using FileMaker Quick Start to open files Working with favorite files and hosts Opening files Opening files with foreign system formats Opening files troubleshooting Using the zoom controls Opening multiple windows per file Arranging windows in FileMaker Pro Closing windows and files Closing files troubleshooting Saving and copying files Quitting FileMaker Pro Adding and viewing data Working with records in Browse mode Viewing records as a form, list, or table Selecting the current record Moving through records Navigating in web viewers Working with data in Table View Displaying and hiding fields in Table View Creating dynamic reports in Table View Adding, duplicating, and deleting records Adding and duplicating records Adding and duplicating related records Deleting records Entering data in records Selecting a field in Browse mode or Find mode Entering and changing data in fields Moving text and data with drag and drop Exporting the contents of a field Working with data in date fields Entering Japanese Emperor Year dates Conversion of dates with two-digit years Working with data in time fields Committing data in records Using URLs in a field Copying and moving data in records Entering preset data from a value list Restoring data in records Using a field index Inserting the current date or other variables into a field Editing and formatting text Selecting text Editing text Formatting text in Browse mode Using data in container fields Inserting graphics into fields Inserting QuickTime movies and multimedia into fields Inserting files of any type into fields Pasting graphics, movies, and sounds from the Clipboard Playing QuickTime and QuickTimeVR movies in fields Recording and playing sounds in fields Working with content in interactive containers Working with PDF files in interactive containers Deleting data from container fields Checking spelling Checking spelling as you type Creating and selecting spelling dictionaries Editing user dictionaries Replacing the contents of a field Adding and viewing data troubleshooting Records are missing Wrong or missing data in field Dates are not as expected Summary data is missing or incorrect Text or objects are clipped Data does not appear correctly List View or Table View refreshes when adding records Can't click or tab into a field Alerts when entering data Value lists troubleshooting Finding, sorting, and replacing data Finding records Performing a quick find in Browse mode Finding records based on criteria in a single field Making a find request Finding text and characters Finding numbers, dates, times, and timestamps Finding ranges of information Finding data in related fields Finding empty or non-empty fields Finding duplicate values Finding duplicate values using a self-join relationship Finding records that match multiple criteria Finding records except those matching criteria Viewing, repeating, or changing the last find Hiding records from a found set and viewing hidden records Constraining (narrowing) a found set Extending (broadening) a found set Finding records troubleshooting Saving a find request Managing saved find requests Sorting records Options for sorting records Sorting records by subsummary values Sorting records troubleshooting Finding and replacing data Find/replace troubleshooting Previewing and printing information Specifying a default printer and paper options (Windows) Specifying printer and paper options (Mac OS) Previewing data on a layout Printing records Printing scripts Printing table and field information Printing the relationships graph Printing troubleshooting Document appears as expected in Preview mode Document does not appear as expected in Preview mode Records not printing Printing troubleshooting techniques (Windows) Printing troubleshooting techniques (Mac OS) Designing and creating databases Creating a database About planning a database Best practices for designing layouts Tips for designing layouts Creating a FileMaker Pro file Setting file options Defining database tables Defining database fields About naming fields About choosing a field type Defining text fields Defining number fields Defining date fields Defining time fields Defining timestamp fields Defining container fields Defining calculation fields Defining summary fields Setting options for fields Defining automatic data entry Defining field validation Defining global fields (fields with global storage) Defining repeating fields Defining field indexing options Defining Furigana options About setting up container fields Setting up container fields to store data externally Managing external storage of container data Managing performance with thumbnails Transferring container data Changing field definitions Changing field names Duplicating field definitions Changing field types Changing calculation formulas Changing summary fields Reordering field definitions Deleting table definitions, field definitions, and data Creating file paths Using variables Working with formulas and functions About functions About formulas Using operators in formulas Identifying text constants and special characters in formulas Adding a new line to the results of a formula Adding comments to a formula Using a reserved word or symbol for a field or table name Getting the contents of a repetition in a repeating field Working with plug-ins Creating custom plug-ins Installing plug-ins Updating plug-ins Plug-in update example Creating and managing layouts and reports Creating a layout Switching between layouts Managing layouts Duplicating, deleting, or renaming layouts Saving and reverting layout changes Reordering and excluding layouts in the Layout pop-up menu Editing layouts Setting up form, list, and table views for a layout Changing the table that a layout shows Setting the automatic record-saving option for a layout Showing or hiding field frames Showing field borders and fill for the current record Specifying a menu set for a layout Changing the theme of a layout Changing the width of a layout Working with layout parts About layout part types Adding a layout part Changing a layout part Changing the background fill and borders of a layout part Defining page breaks and numbering Reordering layout parts Resizing layout parts Deleting layout parts Adding fields to a layout Placing and removing fields on a layout Placing merge fields on a layout Creating portals to display related records Drawing and inserting objects on a layout Working with the layout tools Adding text to a layout Inserting the date, page number, or other variable onto a layout Inserting merge variables onto a layout Drawing lines and other shapes Inserting graphics onto a layout Working with tab controls on layouts Adding a tab control Changing a tab control Selecting and working with objects in tab panels Moving and resizing tab controls Formatting tab controls Copying, duplicating, and deleting tab controls Working with web viewers on layouts Adding a web viewer Changing a web address Defining a custom web address Controlling how layouts print Specifying page margins Showing page margins Setting up to print records in columns Removing blank spaces in printouts Preventing objects from printing Setting up script triggers Setting script triggers for layouts Setting script triggers for objects Changing object data without activating script triggers Troubleshooting layouts Troubleshooting layouts with summary or subsummary parts Troubleshooting label printing Troubleshooting layouts that do not appear or print as expected Troubleshooting layouts designed for both Windows and Mac OS Troubleshooting layouts with web viewers Editing objects on layouts Selecting and working with objects on a layout Selecting objects Using the Inspector to format objects Copying, duplicating, and deleting objects Copying style attributes between objects or layout parts Moving objects on a layout Resizing and reshaping objects Setting auto-resize options for layout objects Setting the fill, line style, and borders on objects Specifying the display state for an object Filling an object or a layout part with a color gradient Filling an object or a layout part with an image Formatting graphics on a layout Protecting objects from change Naming objects Defining conditional formatting for layout objects Formatting and setting up field objects in Layout mode Specifying text formats for fields Specifying formats for fields containing numbers Specifying formats for date fields Specifying formats for time fields Specifying formats for timestamp fields Specifying formats for container fields Adding borders, fill, and baselines to fields Adding scroll bars to fields Defining a value list for data entry Setting up a field to display a pop-up menu, checkbox set, or other control Setting up a field to display a drop-down calendar Setting up a field to auto-complete during data entry Setting up the display of repeating fields Adding tooltips on layouts Showing or hiding badges on layout objects Making layout objects accessible to screen readers Controlling data input behavior of fields Setting the tab order for data entry Allowing or preventing entry into fields Configuring quick find Setting the keys for exiting a field Setting the text input method for fields Setting spell checking for individual fields Formatting text Making text bold, italic, highlighted, or setting other styles Specifying paragraph attributes and tab settings Formatting fields and text for vertical writing Arranging objects Grouping and ungrouping objects Moving objects forward or backward on a layout Rotating objects Aligning or distributing objects Using tools to precisely position objects Using the Inspector to position objects Using the rulers and grid Using guides and dynamic guides Sizing layouts for different devices Showing text or field boundaries Working with related tables and files About relationships About the relationships graph About match fields for relationships About the types of relationships About single-criteria relationships About multi-criteria relationships About relationships using comparative operators About relationships that return a range of records About self-joining relationships Working with the relationships graph Creating relationships Changing relationships Adding tables to the relationships graph Selecting related tables in the relationships graph Duplicating tables in the relationships graph Resizing tables in the relationships graph Aligning tables in the relationships graph Adding text notes to the relationships graph Summarizing data in portals Filtering records in portals About lookups Defining lookups Updating lookup values Creating charts from data About chart types Chart planning guidelines Creating quick charts Creating and editing charts in Layout mode Column, bar, line, and area charts Pie charts Scatter and bubble charts Formatting and scaling chart axes Specifying the data source for a chart Changing the look of a chart Placing your chart in the appropriate layout part Charting tips, tricks, and troubleshooting Example 1: Charting summary data Example 2: Charting delimited data Example 3: Charting related records Creating scripts to automate tasks Planning a script Creating and editing scripts Managing scripts using folders Saving a script Deleting a script Copying and pasting scripts Running scripts on FileMaker Server Importing scripts from other FileMaker files Scripting with ActiveX Automation (Windows) Using FileMaker Pro ActiveX Automation (Windows) ActiveX Automation objects, methods, and properties (Windows) ActiveX Automation example (Windows) Scripting with Apple events (Mac OS) Apple events troubleshooting (Mac OS) Apple events error: "Apple event timed out" (-1712) Apple events error: "Expected expression but found unknown token" Apple events error: "Invalid object containment" (-1723) Apple events error: "Object not found" (-1728) Apple events error: "Data is being accessed by another user, script, or transaction" (-10011) Apple events error: "Set Data failed. Invalid data was supplied" (-17005) Apple events error: "Event failed. User canceled the event processing" (-17006) Apple events error: "Create failed. Invalid data was supplied" (-17007) Working with the Scripts menu Using buttons with scripts Defining a button Copying a button Changing a button definition Deleting a button Script examples If structure example Loop structure example Data entry example A startup script example Perform Script and script parameter example Protecting databases About protecting databases About accounts, privilege sets, and extended privileges About the Admin and Guest accounts Using the predefined privilege sets Planning security for a file Password-protecting a file Creating and managing accounts Viewing and reordering accounts Creating accounts Editing existing accounts Duplicating and deleting accounts Creating accounts that authenticate via an external server Tips for creating account names and passwords Creating and managing privilege sets Viewing privilege sets Creating new privilege sets Editing existing privilege sets Duplicating and deleting privilege sets Editing record access privileges Editing layouts privileges Editing value list privileges Editing scripts privileges Editing extended privileges for a privilege set Editing other privileges Managing extended privileges Viewing extended privileges Editing which privilege sets may use an extended privilege Creating and deleting extended privileges Opening files protected with passwords Changing your password for a file Authorizing access to files Setting up access to a file Sharing data Sharing databases on a network Sharing and hosting files Opening files as the host Closing shared files Working with shared files as a client Opening shared files as a client Opening shared databases remotely using a URL Sending the URL of a shared database Sharing files with FileMaker Go clients Saving, importing, and exporting data Saving and sending records in other formats Saving and sending records as an Excel file Saving and sending records as a PDF file Saving and sending records as a snapshot link Sending email messages based on record data Sending one email message Sending multiple email messages Entering or editing SMTP options Importing data into FileMaker Pro Methods of importing data into an existing file About creating a new table for imported data About validating data during import Importing data into an existing file Setting up recurring imports Importing a folder of files all at once Importing Bento data (Mac OS) Importing XML data Setting the import action and mapping fields during import Converting a data file to a new FileMaker Pro file Exporting data from FileMaker Pro Exporting repeating field data Supported import/export file formats Comma-Separated Text format dBASE III and IV DBF format FileMaker Pro format HTML Table format Merge format Microsoft Excel format Tab-Separated Text format XML format XML FMPDSORESULT grammar XML FMPXMLRESULT grammar Importing and exporting dates Working with Microsoft Excel Publishing databases on the web Using ODBC and JDBC with FileMaker Pro Sharing FileMaker Pro data via ODBC or JDBC Accessing external data sources Configuring an ODBC client driver Connecting to data sources Working with data sources Editing external FileMaker data sources Editing ODBC data sources Enabling ODBC data source single sign-on (Windows only) Updating data between FileMaker and ODBC data sources Restoring links to ODBC data sources Using supplemental fields ODBC data sources troubleshooting Querying an ODBC data source from FileMaker Pro Constructing an SQL query for importing via ODBC Executing SQL to interact with data sources via ODBC Storing an SQL query in a field Automating ODBC import using the Import Records script step Using FileMaker Pro Advanced FileMaker Pro Advanced basics About FileMaker Pro Advanced Your responsibilities as a developer (FileMaker Pro Advanced) Customizing files with FileMaker Pro Advanced Copying and pasting field schemas (FileMaker Pro Advanced) Copying or importing table schemas (FileMaker Pro Advanced) About custom functions (FileMaker Pro Advanced) Using custom functions (FileMaker Pro Advanced) Importing custom functions (FileMaker Pro Advanced) Custom Function dependency rules (FileMaker Pro Advanced) Defining custom menus (FileMaker Pro Advanced) Creating and editing custom menu items (FileMaker Pro Advanced) Creating and editing custom menu sets (FileMaker Pro Advanced) Using FileMaker Pro Advanced tools Debugging scripts (FileMaker Pro Advanced) Disabling script steps (FileMaker Pro Advanced) Using the Data Viewer (FileMaker Pro Advanced) Documenting database schemas (FileMaker Pro Advanced) Setting up files for developer solutions (FileMaker Pro Advanced) Saving solution settings (FileMaker Pro Advanced) Specifying options for developer solutions (FileMaker Pro Advanced) Removing Admin access to databases (FileMaker Pro Advanced) Adding filename extensions to files (FileMaker Pro Advanced) Documenting developer solutions (FileMaker Pro Advanced) About creating runtime solutions (FileMaker Pro Advanced) Preparing files for a runtime solution (FileMaker Pro Advanced) Binding files into a runtime solution (FileMaker Pro Advanced) Naming runtime solutions (FileMaker Pro Advanced) Distributing runtime solutions (FileMaker Pro Advanced) Importing data into upgraded runtime solutions (FileMaker Pro Advanced) Starting runtime solutions (FileMaker Pro Advanced) Recovering runtime files (FileMaker Pro Advanced) Displaying databases in Kiosk mode (FileMaker Pro Advanced) Creating Kiosk solutions (FileMaker Pro Advanced) Using scripts and buttons to control Kiosk solutions (FileMaker Pro Advanced) Creating dynamic buttons (FileMaker Pro Advanced) Reference Setting preferences Setting general preferences Setting layout preferences Setting memory preferences Setting plug-in preferences Setting font preferences Customizing the font menu (Windows) Keyboard shortcuts (Windows) General keyboard shortcuts (Windows) Navigation keyboard shortcuts (Windows) Window display keyboard shortcuts (Windows) Create, delete, and duplicate records keyboard shortcuts (Windows) Paste, select, and replace values keyboard shortcuts (Windows) Mode keyboard shortcuts (Windows) Browse mode keyboard shortcuts (Windows) Find mode keyboard shortcuts (Windows) Layout mode keyboard shortcuts (Windows) Text keyboard shortcuts (Windows) Text deletion keyboard shortcuts (Windows) Text editing keyboard shortcuts (Windows) Text formatting keyboard shortcuts (Windows) Text navigation keyboard shortcuts (Windows) Text selection keyboard shortcuts (Windows) Field type keyboard shortcuts (Windows) Relationships graph keyboard shortcuts (Windows) FileMaker Pro Advanced keyboard shortcuts (Windows) Alert message keyboard shortcuts (Windows) Scroll wheel support (Windows) Keyboard shortcuts (Mac OS) General keyboard shortcuts (Mac OS) Navigation keyboard shortcuts (Mac OS) Window display keyboard shortcuts (Mac OS) Create, delete, duplicate, and save records keyboard shortcuts (Mac OS) Paste, select, and replace values keyboard shortcuts (Mac OS) Mode keyboard shortcuts (Mac OS) Browse mode keyboard shortcuts (Mac OS) Find mode keyboard shortcuts (Mac OS) Layout mode keyboard shortcuts (Mac OS) Text keyboard shortcuts (Mac OS) Text deletion keyboard shortcuts (Mac OS) Text editing keyboard shortcuts (Mac OS) Text formatting keyboard shortcuts (Mac OS) Text navigation keyboard shortcuts (Mac OS) Text selection keyboard shortcuts (Mac OS) Field type keyboard shortcuts (Mac OS) Relationships graph keyboard shortcuts (Mac OS) FileMaker Pro Advanced keyboard shortcuts (Mac OS) Alert message keyboard shortcuts (Mac OS) Scroll wheel support (Mac OS) Functions reference Functions reference (category list) Functions reference (alphabetical list) Aggregate functions Average Count List Max Min StDev StDevP Sum Variance VarianceP Container functions GetHeight GetThumbnail GetWidth VerifyContainer Date functions Date Day DayName DayNameJ DayOfWeek DayOfYear Month MonthName MonthNameJ WeekOfYear WeekOfYearFiscal Year YearName Design functions DatabaseNames FieldBounds FieldComment FieldIDs FieldNames FieldRepetitions FieldStyle FieldType GetNextSerialValue LayoutIDs LayoutNames LayoutObjectNames RelationInfo ScriptIDs ScriptNames TableIDs TableNames ValueListIDs ValueListItems ValueListNames WindowNames External functions External Financial functions FV NPV PMT PV Get functions Get(AccountExtendedPrivileges) Get(AccountName) Get(AccountPrivilegeSetName) Get(ActiveFieldContents) Get(ActiveFieldName) Get(ActiveFieldTableName) Get(ActiveLayoutObjectName) Get(ActiveModifierKeys) Get(ActivePortalRowNumber) Get(ActiveRepetitionNumber) Get(ActiveSelectionSize) Get(ActiveSelectionStart) Get(AllowAbortState) Get(AllowFormattingBarState) Get(ApplicationLanguage) Get(ApplicationVersion) Get(CalculationRepetitionNumber) Get(ConnectionState) Get(CurrentDate) Get(CurrentExtendedPrivileges) Get(CurrentHostTimestamp) Get(CurrentPrivilegeSetName) Get(CurrentTime) Get(CurrentTimestamp) Get(CustomMenuSetName) Get(DesktopPath) Get(DocumentsPath) Get(DocumentsPathListing) Get(ErrorCaptureState) Get(FileMakerPath) Get(FileName) Get(FilePath) Get(FileSize) Get(FoundCount) Get(HighContrastColor) Get(HighContrastState) Get(HostApplicationVersion) Get(HostIPAddress) Get(HostName) Get(InstalledFMPlugins) Get(LastError) Get(LastMessageChoice) Get(LastODBCError) Get(LayoutAccess) Get(LayoutCount) Get(LayoutName) Get(LayoutNumber) Get(LayoutTableName) Get(LayoutViewState) Get(MultiUserState) Get(NetworkProtocol) Get(PageNumber) Get(PersistentID) Get(PreferencesPath) Get(PrinterName) Get(QuickFindText) Get(RecordAccess) Get(RecordID) Get(RecordModificationCount) Get(RecordNumber) Get(RecordOpenCount) Get(RecordOpenState) Get(RequestCount) Get(RequestOmitState) Get(ScreenDepth) Get(ScreenHeight) Get(ScreenWidth) Get(ScriptName) Get(ScriptParameter) Get(ScriptResult) Get(SortState) Get(StatusAreaState) Get(SystemDrive) Get(SystemIPAddress) Get(SystemLanguage) Get(SystemNICAddress) Get(SystemPlatform) Get(SystemVersion) Get(TemporaryPath) Get(TextRulerVisible) Get(TotalRecordCount) Get(TriggerCurrentTabPanel) Get(TriggerKeystroke) Get(TriggerModifierKeys) Get(TriggerTargetTabPanel) Get(UserCount) Get(UserName) Get(UseSystemFormatsState) Get(UUID) Get(WindowContentHeight) Get(WindowContentWidth) Get(WindowDesktopHeight) Get(WindowDesktopWidth) Get(WindowHeight) Get(WindowLeft) Get(WindowMode) Get(WindowName) Get(WindowStyle) Get(WindowTop) Get(WindowVisible) Get(WindowWidth) Get(WindowZoomLevel) Logical functions Case Choose Evaluate EvaluationError ExecuteSQL GetAsBoolean GetField GetFieldName GetLayoutObjectAttribute GetNthRecord If IsEmpty IsValid IsValidExpression Let Lookup LookupNext Self Mobile functions Location LocationValues Number functions Abs Ceiling Combination Div Exp Factorial Floor Int Lg Ln Log Mod Random Round SetPrecision Sign Sqrt Truncate Repeating functions Extend GetRepetition Last Summary functions GetSummary Text functions Char Code Exact Filter FilterValues GetAsCSS GetAsDate GetAsNumber GetAsSVG GetAsText GetAsTime GetAsTimestamp GetAsURLEncoded GetValue Hiragana KanaHankaku KanaZenkaku KanjiNumeral Katakana Left LeftValues LeftWords Length Lower Middle MiddleValues MiddleWords NumToJText PatternCount Position Proper Quote Replace Right RightValues RightWords RomanHankaku RomanZenkaku SerialIncrement Substitute Trim TrimAll Upper ValueCount WordCount Text formatting functions RGB TextColor TextColorRemove TextFont TextFontRemove TextFormatRemove TextSize TextSizeRemove TextStyleAdd TextStyleRemove Time functions Hour Minute Seconds Time Timestamp functions Timestamp Trigonometric functions Acos Asin Atan Cos Degrees Pi Radians Sin Tan Script steps reference Script steps reference (category list) Script steps reference (alphabetical list) Control script steps Perform Script Pause/Resume Script Exit Script Halt Script If Else If Else End If Loop Exit Loop If End Loop Allow User Abort Set Error Capture Set Variable Install OnTimer Script Navigation script steps Go to Layout Go to Record/Request/Page Go to Related Record Go to Portal Row Go to Object Go to Field Go to Next Field Go to Previous Field Enter Browse Mode Enter Find Mode Enter Preview Mode Editing script steps Undo/Redo Cut Copy Paste Clear Set Selection Select All Perform Find/Replace Fields script steps Set Field Set Field By Name Set Next Serial Value Insert Text Insert Calculated Result Insert From Index Insert From Last Visited Insert From URL Insert Current Date Insert Current Time Insert Current User Name Insert Picture Insert QuickTime Insert Audio/Video Insert PDF Insert File Replace Field Contents Relookup Field Contents Export Field Contents Records script steps New Record/Request Duplicate Record/Request Delete Record/Request Delete Portal Row Delete All Records Open Record/Request Revert Record/Request Commit Records/Requests Copy Record/Request Copy All Records/Requests Import Records Export Records Save Records As Excel Save Records As PDF Save Records As Snapshot Link Found Sets script steps Perform Find Perform Quick Find Find Matching Records Constrain Found Set Extend Found Set Modify Last Find Show All Records Show Omitted Only Omit Record Omit Multiple Records Sort Records Unsort Records Sort Records by Field Windows script steps New Window Select Window Close Window Adjust Window Move/Resize Window Arrange All Windows Freeze Window Refresh Window Scroll Window Show/Hide Toolbars Show/Hide Text Ruler Set Window Title Set Zoom Level View As Files script steps New File Open File Close File Convert File Set Multi-User Set Use System Formats Save a Copy as Recover File Print Setup Print Accounts script steps Add Account Delete Account Reset Account Password Change Password Enable Account Re-Login Spelling script steps Check Selection Check Record Check Found Set Correct Word Spelling Options Select Dictionaries Edit User Dictionary Open Menu Item script steps Open Edit Saved Finds Open Preferences Open File Options Open Manage Containers Open Manage Database Open Manage Data Sources Open Manage Layouts Open Manage Scripts Open Manage Value Lists Open Find/Replace Open Help Open Remote Open Sharing Miscellaneous script steps Show Custom Dialog Allow Formatting Bar Beep Speak (Mac OS) Dial Phone Install Plug-In File Install Menu Set Set Web Viewer Open URL Send Mail Send DDE Execute (Windows) Perform AppleScript (Mac OS) Execute SQL Send Event (Mac OS) Send Event (Windows) Comment Flush Cache to Disk Exit Application Script triggers reference OnObjectEnter OnObjectKeystroke OnObjectModify OnObjectValidate OnObjectSave OnObjectExit OnTabSwitch OnRecordLoad OnRecordCommit OnRecordRevert OnLayoutKeystroke OnLayoutEnter OnLayoutExit OnModeEnter OnModeExit OnViewChange OnFirstWindowOpen OnLastWindowClose OnWindowOpen OnWindowClose FileMaker Pro features by version Maintaining and recovering FileMaker Pro databases Backing up Example backup script Saving a compacted copy About recovering FileMaker Pro files Preventing database damage Damaged files Damaged layouts Checking file consistency Recovering files Setting advanced file recovery options Troubleshooting file recovery FileMaker Pro error codes Glossary Registration Customer support and Knowledge Base Copyright information