For Windows and Mac FileMaker Pro 6 User’s Guide ©1995, 19972002 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 www.filemaker.com FileMaker documentation is copyrighted. You are not authorized to make additional copies or distribute this documentation without written permission from FileMaker. You may use this documentation solely with a valid licensed copy of FileMaker software. FileMaker is a trademark of FileMaker, Inc., registered in the U.
Contents Preface Learning how to use FileMaker Pro Registration and customer support xi Using the FileMaker Pro documentation xi How this guide is organized xii A note about the illustrations xii Using FileMaker Pro Help xiii Starting FileMaker Pro Help xiii About the Help topic window xiii Finding a topic using the Help Contents xiii Finding a topic using the Help Index xiv Finding a topic using specific words xv Finding information on specific items in FileMaker Pro xvi Getting additional Help xvi Using o
iv FileMaker Pro User’s Guide About working with text Selecting text Editing text Formatting text in Browse mode Checking spelling Checking spelling as you type Working with OLE objects 2-13 2-13 2-14 2-14 2-14 2-15 2-15 Chapter 3 Finding and sorting information Finding records Finding text and characters Finding exact matches in text fields Finding numbers, dates, and times Finding ranges of information Finding data in related fields Finding records that match multiple criteria Finding empty or nonemp
Contents About working with objects on a layout Working with the layout tools Selecting objects Copying, duplicating, and deleting objects Moving objects on a layout Changing an object’s shape and size Protecting objects from change About working with fields on a layout Placing and removing fields on a layout Deciding where to place related fields Formatting field data on a layout About layout parts About layout part types Adding or changing layout parts Defining page breaks and numbering Reordering layout
vi FileMaker Pro User’s Guide Summarizing data in portals Defining lookups between files Defining lookups Accessing related data from a third file Creating manytomany relationships 8-12 8-13 8-13 8-14 8-15 Chapter 9 Protecting databases with passwords and groups Defining passwords Deleting or changing passwords Defining groups Deleting or changing groups Passwords and groups: a comparison 9-1 9-3 9-3 9-5 9-6 Chapter 10 Creating scripts to automate tasks About scripts Creating scripts: an overview Pl
Contents Chapter 12 Importing and exporting data About import and export About file formats Importing data into FileMaker Pro Importing data into an existing file Converting a data file into a new FileMaker Pro file Exporting data from FileMaker Pro Exporting subsummary data 12-1 12-1 12-2 12-2 12-6 12-6 12-8 Chapter 13 Sharing databases on a network About sharing files on a network Working with shared files About hosting files Opening files as the host Closing shared files Opening files as a guest 13-1
viii FileMaker Pro User’s Guide Importing data from an ODBC data source: an overview Configuring the ODBC control panel Connecting to an ODBC data source from FileMaker Pro Building a SQL query in FileMaker Pro Importing the results of the query into FileMaker Pro An ODBC import example Configuring the ODBC control panel for the Text driver Connecting to the ODBC Demo data source Specifying the SQL query in FileMaker Pro Importing ODBC data with a join Specifying a SQL join Automating ODBC connections 15
Preface Learning how to use FileMaker Pro The documentation for the FileMaker® Pro software provides information, illustrations, and stepbystep instructions to help you learn the most about FileMaker Pro.
x FileMaker Pro User’s Guide How this guide is organized Special information in this user’s guide looks like this: This FileMaker Pro User’s Guide describes how to use the most common features in FileMaker Pro. For details about some advanced features, as well as new features added in FileMaker Pro 5.5 and FileMaker Pro 6, see FileMaker Pro Help. Note or Tip messages give extra or helpful information about a subject.
Learning how to use FileMaker Pro Using FileMaker Pro Help FileMaker Pro onscreen Help is available whenever FileMaker Pro is running. It contains some information not in the printed documentation, such as troubleshooting tips or alternative ways of performing an action.
xii FileMaker Pro User’s Guide To use the Help Index: 1. In FileMaker Pro, choose Help menu > Contents and Index, then click the Index tab. Or click the Help Topics button in any Help topic window, then click the Index tab. 2. In the Index window, type all or part of an index entry that you want to find. Help Contents in FileMaker Pro Help for Windows The Help Index displays a list of entries beginning with the characters you typed. Under some index entries is a list of more than one Help topic.
Learning how to use FileMaker Pro Finding a topic using specific words If you can’t find the information you’re looking for in the Help Contents or in the Index, you can specify your own significant word or combination of words to search for within all of the Help topics. FileMaker Pro Help displays a list of all topics containing the word(s) you specify and the total number of topics found. To narrow the search, you can specify a combination of words.
xiv FileMaker Pro User’s Guide Finding information on specific items in FileMaker Pro • Choose Help menu > Show Balloons, then point to a control in the As you’re working in your database, you can find information about a dialog box that’s open or certain items your mouse is pointing to, depending on the platform you’re using. database window or select a command from a menu to find out about it.
Learning how to use FileMaker Pro Using other tools Use the following additional tools to help you with FileMaker Pro. Use To FileMaker Pro Install FileMaker Pro on your hard disk. Also, use the Getting Started Guide tutorial to get an overview of how to use and design a FileMaker Pro database. If you’ve used previous versions of FileMaker Pro, you can read about features new to this version. FileMaker Pro template files See and work with database files created with FileMaker Pro.
Part 1 Using a database
Chapter 1 FileMaker Pro basics This chapter presents basic information about databases and using FileMaker Pro. You’ll learn about: N M Records • working with fields and records • using FileMaker Pro modes • performing menu commands • managing files If you’re new to FileMaker Pro, start by reviewing the tutorial, included in the FileMaker Pro Getting Started Guide.
1-2 FileMaker Pro User’s Guide Products file Clients file Client ID 002 Prod ID ET3 Name Andre Common Product Travel bag Phone 818-555-1234 Price $29.00 Stock 34 Invoice file Client ID 002 Client Name Andre Common Phone 818-555-1234 Invoice ID 12345 Prod ID Product ET3 Travel bag ET4 Travel book A record in the Clients database Price $29 $32 FileMaker Pro includes template files that you can use to get started right away.
FileMaker Pro basics • date • time • graphic, sound, movie, or, for Windows only, OLE • the result of a formula that calculates the field’s value • a summary of the values in the field for a group of records About layouts FileMaker Pro layouts determine how information is organized for viewing, printing, reporting, finding, and entering data. Layouts do not store your data—they just display it. Database files can have many different layouts, which display data in a variety of ways.
1-4 FileMaker Pro User’s Guide In this mode You do this Preview See how data in forms or reports will look before you print. Preview mode is especially useful for layouts with multiple columns (like mailing labels) and grouped reports with summaries. • If you’re sharing data using FileMaker Pro networking on a network and have more than ten guests, you must host the files using FileMaker Server. For information, see chapter 13, “Sharing databases on a network.
FileMaker Pro basics Using toolbars Toolbars provide quick access to many FileMaker Pro menu commands. Hold the cursor over a button to see its description. Tooltips describe each button in the toolbar Toolbar buttons vary depending on which mode you’re using. For example, the standard toolbar in Browse mode contains buttons that help you create or delete records. In Find mode, the buttons help you create or delete find requests.
1-6 FileMaker Pro User’s Guide • Drag a FileMaker Pro file on top of the FileMaker Pro icon • Windows: click the Start button, and choose FileMaker Pro from the Programs menu. Opening files To open a file if FileMaker Pro is already running: Context menu in Browse mode 1. Choose File menu > Open. 2. Doubleclick the name of the file to open. Context menu in Layout mode To display a context menu in Windows, hold down the right mouse button while the pointer is over an object or data.
FileMaker Pro basics Keep these points in mind: • When you open a file created with an earlier version of FileMaker Pro (version 4.1 and earlier), you must convert it to the current FileMaker Pro file format. Upon conversion, date fields that were previously storing and displaying twodigit years (for example, 92) will now display fourdigit years (for example, 1992). You might have to resize the date fields to display four digits or format the date field to display two digits.
1-8 FileMaker Pro User’s Guide Choose this option Clone (no records) Quitting FileMaker Pro To do this Make a copy that contains all the field definitions, layouts, scripts, and page setup options, but no data. Make a clone when you want a template of the file. 3. Type a new name to rename the file. Name of the new file Filename extension Options for saving a copy Save a Copy As dialog box (Windows) Name of the new file Options for saving a copy Save a Copy As dialog box (Mac OS) 4. Click Save.
Chapter 2 Adding and viewing data There are many ways to view and work with data in a FileMaker Pro database. This chapter explains how to: • view records in a database • add, duplicate, and delete records • add and edit data in fields • work with text in fields • check the spelling of your data For an introduction to fields and records, see “About fields and records” on page 12.
2-2 FileMaker Pro User’s Guide Viewing records Keep these points in mind: FileMaker Pro provides three views of each layout: form, list and table. When you change views, you temporarily change the way records display or print. To view Do this in Browse mode, Find mode, or Preview mode Individual records Choose View menu > View as Form. Records in a list Choose View menu > View as List. Records in a table Choose View menu > View as Table. (See the next section, “Viewing records in a table.
Adding and viewing data 2. If FileMaker Pro prompts you to save your changes to the layout, you can choose how the layout is displayed the next time you open the file. To Click See your layout changes Yes See the layout as it looked before your changes No 2-3 • For more information about View as Table, choose Help menu > Contents and Index, click the Index tab, and type View as Table command. Selecting the current record In Browse mode, a database has one current (selected) record at a time.
2-4 FileMaker Pro User’s Guide To move Do this Quickly through records Drag the bookmark down or up to move forward or backward. Through records in Use the scroll bar on the right side of the window. View as List or View as Table To a record with a unique value that you know Portal See “Finding records” on page 31. Adding and duplicating records Click inside the portal row to select a related record Moving through records To move from one record to another, use the book icon in the status area.
Adding and viewing data If the field is defined to enter field values automatically, you see those values entered in the new record. See “Defining automatic data entry” on page 58. 2-5 Master file To enter or change values in the new record, see “About entering data in records” on page 26. Adding and duplicating related records If you’re working with related files, you can add records to the related file as you enter data in a record in the master file.
2-6 FileMaker Pro User’s Guide If you’re working in a relational database and the option to delete related records is selected in the Edit Relationship dialog box, FileMaker Pro deletes related records when you delete a master record. For more information, see “Defining relationships for relational databases and lookups” on page 810. To delete Do this One record In Browse mode, select the record to delete.
Adding and viewing data Entering and changing data in fields You can enter data up to the character limit for the field type (for example, 255 characters in a number field). You can view and print only the data that fits within the field boundaries. To Do this in Browse mode Delete data from a field Select the data, then press Backspace or Delete. Edit, format, or check the spelling of text in a field See “About working with text” on page 213.
2-8 FileMaker Pro User’s Guide • There are other ways to enter data in a field besides typing, like importing or copying it from another source, using a related file, or having FileMaker Pro automatically enter the data when you create a record. See “About import and export” on page 121,“Displaying data from related files” on page 81, and “Defining automatic data entry” on page 58. • For more information about entering and changing data, see FileMaker Pro Help.
Adding and viewing data Pop-up menu Pop-up list Choose to edit values in the list Radio buttons Click to enter a value that isn’t included in the list Do this in Browse mode Choose preset value from Click the field, then choose the value from the pop a popup (dropdown) list up list or menu.
2-10 FileMaker Pro User’s Guide Inserting the current date or other variable into fields Before you begin, keep these points in mind: To insert the current date, time, or user name into a field in Browse mode or Find mode: • Important You can’t undo replacing field values. Before you begin, consider making a copy of the file. 1. Click the field. 2. Choose Insert menu > Current Date, Current Time, or Current User • You can’t replace data in calculation, summary, or global fields.
Adding and viewing data To replace each field with A serial number Select Replace with serial numbers. Type the starting value for the serial numbers in Initial value, and the incremental value in Increment by. (FileMaker Pro enters serial numbers starting with the first record in the found set). If the field is defined to automatically enter a serial number, you can: 1 Select Update serial number in Entry Options to reset the next value in the Options for Field dialog box.
2-12 FileMaker Pro User’s Guide To reduce the database file size, select Store only a reference to the file (Windows) or Store file reference (Mac OS). However, if the file is moved or deleted, FileMaker Pro can’t display the graphic. To store the graphic in the file, clear the option. • The multimedia displayed in a container field is a reference to a multimedia file.
Adding and viewing data QuickTime VR 3.0 movie controls Click to return to the previous view after clicking a hot spot Zoom in or out 2-13 About working with text Click and drag across the movie to change the view In Browse mode and Find mode, you can work with text data in fields. In Layout mode, you can work with the text that displays on a layout.
2-14 FileMaker Pro User’s Guide Tip In Layout mode, use the selection tool to manipulate a block of text as if it were an object (for example, to change fonts). When a text block is selected with the selection tool, typing replaces the text in the text block. For more information, see “Selecting objects” on page 612. Editing text 1. Select the text you want to edit. (See the previous section.) 2. Type new text or make changes. Important You can change text attributes for data in Browse mode.
Adding and viewing data To check the spelling of Choose Text on the current layout (in Layout mode) Check Layout Text in the found set of records Check All 2-15 For more information about adding or removing words from a dictionary, see FileMaker Pro Help. Choose Help menu > Contents and Index, click the Index tab, and type dictionaries. Checking spelling as you type 3. In the Spelling dialog box, choose an option if a questionable word appears in the Word box.
Chapter 3 Finding and sorting information This chapter shows you how to: • find records in your database using many different criteria • omit records from the found set • sort records You can then work with just the records in the found set. For example, you can view, edit, calculate summaries for, sort, print, delete, export, or replace data in these records. To define a find request: 1. Go to a layout that has fields you want to enter criteria in.
3-2 FileMaker Pro User’s Guide Choose a layout with fields you want to search on Type Find criteria in fields • Finds on unindexed fields (for example, calculation fields referencing related fields) can take longer than finds on indexed fields. • If a field’s values are indexed, you can use the index to enter values Click the down arrow to see the operators Click to begin searching 4. Click Find in the status area, or choose Requests menu > Perform Find. in find requests.
Finding and sorting information To find Type this in the field Example Symbols or other non alphanumeric characters, such as punctuation or spaces The characters, including spaces and punctuation, between the double quotation marks ("). "@" finds @ (or an email address, for example) The text, including spaces and punctuation, between the double quotation marks (").
3-4 FileMaker Pro User’s Guide To find Type this in the field Example Finding ranges of information A Boolean number in a number field or in a calculation field that produces a Boolean result True, Yes, Y, y, T, t, or 1 to find True values T finds True, Yes, Y, y, T, t, and 1 Use this operator Example To find values that are 0 finds False, No, N, n, F, f, Less than a specified value.
Finding and sorting information 3-5 For information about omitting related records, see “Finding all records except those matching criteria” on page 36. Example: to find all people named Smith who work in Sales, type Smith in the LastName field and Sales in the Department field. Find request Records that match at least one of the sets of criteria, but not necessarily all (logical OR search) Invoice ID To widen your search, enter criteria in the first request. Choose Requests menu > Add New Request.
3-6 FileMaker Pro User’s Guide To restore a request to the way it was when you last committed it, choose Requests menu > Revert Request. Requests are committed, for example, when you click out of all fields, go to a different layout or request, or perform a Find. Click a page of the book to see another find request You determine the field on which uniqueness is based.
Finding and sorting information 3-7 Finding some records while omitting others Hiding records from a found set and viewing hidden records For example, to find vendors in the state of New York, except those in New York City: All records that are not in the found set are omitted, or hidden. You can omit additional records from the found set without doing a new find. 1. In Find mode, type the criteria for the records to find (type New York in the State field.) 2. Choose Requests menu > Add New Request.
3-8 FileMaker Pro User’s Guide Sorting records To cancel before sorting is finished, press Esc (Windows) or Command+period (Mac OS.) FileMaker Pro stores records in the order they were added to the file. Sorting temporarily rearranges records, so you can view, update, or print them in a different sequence. To You choose the fields whose contents you want to sort by. The first sort field arranges the records based on the field’s contents.
Finding and sorting information To Do this Include related fields anywhere Choose a relationship from the relationship in the sort order list, then doubleclick a related field in the list. 3-9 Keep these points in mind: • Data sorts differently in different field types: This field type Sorts records in this order Text Alphabetically. Numbers sort by character position. (Example of an ascending sort: 1, 11, 2.) Numbers sort before letters.
3-10 FileMaker Pro User’s Guide • When you define a text field, the default language for indexing and sorting text is determined by the operating system on which FileMaker Pro is running. If you want to override the default language for a sort, select Override field’s language for sort in the Sort Records dialog box.
Chapter 4 Previewing and printing information This chapter describes how to: • set up a printer and print options • preview before you print • print one or more records, a blank record, field definitions, or script You can print data based on the current layout or information about the structure of the database steps The procedures in the chapter assume that you already have a layout to print. If you don’t, see chapter 6, “Creating and managing layouts and reports,” and chapter 7, “Customizing layouts.
4-2 FileMaker Pro User’s Guide Preparing to print Note Printer and print setup options depend on the printer and system software you’re using. Refer to your printer and system documentation for more information. Specifying a printer (Windows) You can specify a default printer to be used when you print in FileMaker Pro. You can also specify a different printer each time you print.
Previewing and printing information 4-3 Preparing to print layouts with subsummaries When you’re using individual sheets of labels: If you’re printing a layout with one or more subsummary parts, sort the records by the break field (the field that groups the records) associated with each subsummary part. See “Viewing or printing subsummary or grand summary data” on page 628 and “Sorting records” on page 38. Then switch to Preview mode.
4-4 FileMaker Pro User’s Guide • records arranged in columns if the Layout Setup is defined to print in columns (see “Setting up to print records in columns” on page 68) To preview data on a layout, you follow the same preliminary steps that you perform when you print, including specifying a printer and printing options and verifying that the found set contains the records you want to preview (see steps 1 through 4 in the next section, “Printing”). Then, choose View menu > Preview Mode.
Previewing and printing information Mac OS: Depending on the version of the printing software you are using, you may need to choose FileMaker Pro from the popup menu to see these options.
4-6 FileMaker Pro User’s Guide • When you print a field or a portal with a scroll bar, FileMaker Pro prints only the data visible without scrolling. To print all the data, duplicate the layout and enlarge the field or portal, then specify sliding options to remove the extra blank space when you print. See “About removing blank space from printed data” on page 722. • To keep any object on a layout from printing, select it in Layout mode, and choose Format menu > Sliding/Printing.
Part 2 Designing and creating a database
Chapter 5 Creating a database This chapter explains how to: • plan a database • create a FileMaker Pro database file • define, modify, or delete fields in your database Planning a database file Plan a database before you create it to save time and effort later on. Although you can change the design later, the more you plan ahead, the fewer changes you’ll need to make. Start with a simple design, use it for a while, then change it as needed. Follow these general steps to plan a database: 1.
5-2 FileMaker Pro User’s Guide 2. In the New Database dialog box, do the following: Sample Database Design Form Project Name Purpose of this database File name for this database Fields Name Type Comments To Do this Create a file using a template Select Create a new file using a template, then double click the name of a template. Create a file without using a template Select Create a new empty file, then click OK. Open an existing file See “Opening files” on page 16.
Creating a database About defining database fields To define a new field, you give it a name. Then you select options that determine how the field interprets, enters, calculates, stores, and displays data. These characteristics make up the field definition. Product ID ET14 Product Name Jacket These fields store text 5-3 Keep these points in mind: • You can duplicate a field definition to define a new field that’s similar to an existing field. See “Changing field definitions” on page 511.
5-4 FileMaker Pro User’s Guide About choosing a field type When you define a field, you must select the appropriate field type. FileMaker Pro uses the field type to interpret the data for tasks like sorting and performing calculations. Sales Report Select this field type Text Number If the field data will be Up to approximately 64,000 letters, symbols, or numbers used as text. Text fields may contain carriage returns. Dates only. Time Times only.
Creating a database • For information about working with data in fields, see “About entering data in records” on page 26. For more information about field types, choose Help menu > Contents and Index, click the Index tab, and type field types. 5-5 For more information about defining fields, choose Help menu > Contents and Index, click the Index tab, and type defining fields. Defining calculation fields 1. Choose File menu > Define Fields. Defining text, number, date, time, or container fields 1.
5-6 FileMaker Pro User’s Guide 6. To select indexing and storage options for the field, click Storage Options, select options, then click OK. Select comparison and logical operators Select mathematical and text operators Choose the way functions are listed in the dialog box Choose a relationship from the list 7. Click OK to close the Specify Calculation dialog box. 8. Continue defining fields, or click Done.
Creating a database 4. In the Options for Summary Field dialog box, select a summary type, then select the name of the field you want to group by. 5-7 5. Select an option, if applicable, for the summary type. Options change according to the summary type you select in the previous step.
5-8 FileMaker Pro User’s Guide Defining global fields 5. Click OK. A global field contains one value that’s used for all records in a file. (You can’t use a global field for finding data.) Use the value of a global field: 6. Continue defining fields, or click Done.
Creating a database 3. In the Options for Field dialog box, click the Auto-Enter tab and select options. (The available options depend on the field type.) 5-9 Click Auto-Enter Important To avoid confusion when using dates in FileMaker Pro, set field validation options to make sure dates are always entered with fourdigit years. (See the next section.) To Do this Enter the date, time, or Select the first checkbox (the), then choose an user name when the record option from the list.
5-10 FileMaker Pro User’s Guide 3. In the Options for Field dialog box, click the Validation tab and Click Validation select options. To verify that the entered value Do this Contains only numbers Select Strict data type, then choose Numeric Only from the list. Select validation options for the field Is a date containing numeric values Select Strict data type, then choose for the month and day, and four digits 4-Digit Year Date from the list.
Creating a database 5-11 About repeating fields Changing field definitions A repeating field holds more than one value (up to 1000), each in a separate repetition of a field. Any field type, except summary, can be a repeating field. Important When you change the definition of a field that contains data, the data in that field could be affected. For more information about the effects of changing fields, choose Help menu > Contents and Index, click the Index tab, and type field definitions.
5-12 FileMaker Pro User’s Guide To Do this Change a summary In the field list, doubleclick the summary field, then field make your changes in the Options for Summary Field dialog box. Click OK. See “Defining summary fields” on page 56. Reorder field names in dialog boxes that list fields See FileMaker Pro Help. Choose Help menu > Contents and Index, click the Index tab, and type reordering. 3. Click Done.
Chapter 6 Creating and managing layouts and reports This chapter describes how to manage layouts to present data for onscreen display or printing.
6-2 FileMaker Pro User’s Guide For more information about setting up layouts for web publishing, see “Setting up browser views” on page 1210. You see the New Layout/Report assistant, a series of dialog boxes, or panels, that assist you with creating the type of layout you choose in the first panel. Creating layouts and reports 3.
Creating and managing layouts and reports 6-3 4. When you have completed the series of panels, click Finish to Columnar list/report create the layout. Use a Columnar list/report layout when you want to view or print multiple records in rows (a list of records). You can define many variations of a Columnar list/report with the New Layout/Report assistant.
6-4 FileMaker Pro User’s Guide • Add header and footer parts with static text (like your company’s name), dynamic text (like the page number or current date), or a graphic (like your company logo). • Save information in a script to rerun the report (for example, switch to the report layout, sort the data, and pause to let you preview the report). You can modify any of these options after you complete the assistant.
Creating and managing layouts and reports Envelope Use an Envelope layout to print the fields you select, arranged to print on a standard “Number 10” business envelope. 6-5 • If your layout doesn’t turn out the way you expect it to, you can go through the assistant again. Remember to delete the layout that you no longer need (see “Working with, duplicating, deleting, or renaming layouts” on page 68).
6-6 FileMaker Pro User’s Guide • A Columnar list/report layout arranges fields in columns. (For information on arranging records in columns, for example, to print a directory of names and addresses, see “Setting up to print records in columns” on page 69.) • If you plan on printing a Columnar list/report and the columns extend beyond the width of a page, try one or more of the following: • Reduce the field size or the font size for data in fields. • Change the page orientation to horizontal (landscape).
Creating and managing layouts and reports • For continuousfeed label paper, create a custom paper size equal to the height of one label. (Use a custom paper size to minimize the backandforth movement of the printer platen and to save label paper.) Specific instructions vary depending on the type of printer: Windows: Click Properties. If your printer supports creating a custom paper size, you see in the Properties dialog box Paper tab, a Custom icon for Paper size.
6-8 FileMaker Pro User’s Guide Note FileMaker Pro uses merge fields when you create an Envelope layout. You can’t enter or edit data using merge fields. Switch to Table view (in Browse mode, choose View menu > View as Table) or use another layout for that purpose. For more information about working with merge fields, see “Placing merge fields” on page 618. For more information about different views, see “Viewing records” on page 22.
Creating and managing layouts and reports 6-9 4. In the Layout Setup dialog box, General tab, select Print in When you set up records to print in columns, all the field values (and labels, if specified) for one record are printed together in a block (much like on a label), then all the values for the next record are printed together, and so on. You see multiple columns only in Layout and Preview modes and when you print (not in Browse mode or Find mode).
6-10 FileMaker Pro User’s Guide Note Use merge fields or fields or objects with sliding enabled to fit more data into the width of a column. With either of these two features, fields can extend into the gray area of the second column, and blank space in fields is eliminated when you view or print data. See “Placing merge fields” on page 618 and “About removing blank space from printed data” on page 722. 3. In the Layout Setup dialog box, click the Views tab, then select one or more views.
Creating and managing layouts and reports Keep these points in mind: • FileMaker Pro doesn’t display subsummary layout parts when you 6-11 In Browse mode, objects look the same from record to record, while field data changes to show the data in your database. specify View as List in Browse mode or Find mode. You see subsummary parts and subsummary data calculated correctly only in Preview mode or in a printed report (see “Viewing or printing subsummary or grand summary data” on page 628).
6-12 FileMaker Pro User’s Guide Note If you don’t see the tool panel at the left side of the document window, the status area might be hidden. Make sure you’re in Layout mode (choose View menu > Layout Mode), then click the status area at the bottomleft corner of the document window.
Creating and managing layouts and reports • If multiple objects are grouped, you can’t move an individual object within the group until you ungroup the objects. Select the grouped object, then choose Arrange menu > Ungroup (see “Grouping and ungrouping objects” on page 717). • You can layer objects on a layout. If you can’t see an object on a layout, you might need to send other objects backwards in the stacking order.
6-14 FileMaker Pro User’s Guide • Use the Duplicate command to create a series of equally spaced identical objects. After choosing Edit menu > Duplicate, immediately drag the new object to the position you want (without deselecting it). Choose Duplicate again: the new copy appears in the same position relative to the first copy as the first copy is to the original object. • To move a portal and the related fields and objects within it, select the portal by clicking its border and the objects within it.
Creating and managing layouts and reports To Do this Override the object grids when dragging a handle Press Alt (Windows) or 2 (Mac OS) as you drag a handle. Keep these points in mind: 6-15 Fields on a layout are objects, which you can select, move, resize, and reshape (see the previous sections). In Layout mode, each field displays its field name, formatted with its attributes for font, size, style, alignment, line spacing, and color.
6-16 FileMaker Pro User’s Guide You get different results by placing the same field in different locations on the layout. For example: • Add the same summary field to a subsummary part to calculate totals for each group of sorted records, and to a grand summary part to get totals for all the records in the database. Field tool The field’s border and baselines appear as you drag the fields onto the layout 3. In the Specify Field dialog box, select the field to place.
Creating and managing layouts and reports 6-17 To remove a field from a layout, in Layout mode, click the field to select it, then press Backspace or Delete, or choose Edit menu > Clear. Removing a field from a layout does not delete the field or its data from your database. (To delete a field and its data, see “Deleting field definitions and data” on page 512.
6-18 FileMaker Pro User’s Guide To place a merge field on a layout: 1. In Layout mode, click with the arrow pointer where you want FileMaker Pro to place the merge field. To insert the merge field into a line of text, click the text tool (in the tool panel), then click where you want to set the insertion point in the text. 2. Choose Insert menu > Merge Field. 3. In the Specify Field dialog box, select the field to insert.
Creating and managing layouts and reports 6-19 For example, you might do the following on an Invoice layout in an Invoices database: • Place related fields on the invoice that displays data from the Clients database, such as the client’s identification number and contact information. (The match field is Client ID.) There is only one record in the Clients database for each Client ID, so each related field on the invoice displays the data for that client.
6-20 FileMaker Pro User’s Guide 2. Position the crosshair pointer on the layout where you want the portal to begin, then drag the pointer diagonally until the portal is the size you want. 3. In the Portal Setup dialog box, for Show records from, choose the relationship to use. Or choose Define Relationships to create a relationship (see “Defining relationships for relational databases and lookups” on page 1210).
Creating and managing layouts and reports • To change the number of rows, the color or pattern of alternating rows, or whether a scroll bar appears in a portal, doubleclick the portal. In the Portal Setup dialog box, change formatting options, then click OK. • For information about working with portals in databases published on the Web using the FileMaker Pro Web Companion, choose Help menu > Contents and Index, click the Index tab, and type layouts,on Web.
6-22 FileMaker Pro User’s Guide • In Layout mode, to set default field attributes from the attributes of an existing field (for example, to specify that all new text fields you place have text attributes that match an existing field or all new number fields you place have number formats that match an existing field), Ctrlclick (Window) or 2click (Mac OS) the existing field. Specifying text formats for fields In Layout mode, you can specify a set of text character attributes for each type of field.
Creating and managing layouts and reports For more complete information about specifying number formats, see the FileMaker Pro onscreen Help. Choose Help menu > Contents and Index, click the Index tab, and type number fields. 4. Click OK.
6-24 FileMaker Pro User’s Guide • If you specify Leave date formatted as entered but a year is entered with only two digits, FileMaker Pro stores, displays, and prints the year with four digits to include the century. • Be sure to size the date field on the layout according to the format you choose. For example, the date Wednesday, May 5, 2002 needs more room than 5/5/02. • Use any of the date formatting options to format the date symbol, “//” (two slashes), which displays the current date.
Creating and managing layouts and reports About layout parts 6-25 About layout part types FileMaker Pro layouts are divided into layout parts, sections of the layout that determine how data in a field is treated and displayed.
6-26 FileMaker Pro User’s Guide To include summary data on a layout (for example, subtotals, grand totals, averages, counts, and so on), you place summary fields in summary layout parts (see “Defining summary fields” on page 56). Summary parts include grand summary and subsummary parts. • A grand summary part usually contains one or more summary fields that display summary information (like totals) about all records being browsed.
Creating and managing layouts and reports 6-27 3. In the Part Definition dialog box, make your changes. Select the type of part to create Select options for page numbering and breaks Part types that are already on the layout are dimmed (only subsummary parts can exist more than once on a layout). 4. If you’re adding a subsummary part, after you click Sub-summary when sorted by, select the name of the field that you want to group the records by (the break field).
6-28 FileMaker Pro User’s Guide • For more information about setting up layouts for web publishing, see “Setting up browser views” on page 1210. • To apply a color or pattern to a layout part, click the part label, then, in the status area, choose from the fill color palette, fill pattern palette, or both. (The color you specify for the body part also affects the background of the table in View as Table.
Creating and managing layouts and reports 6-29 Defining page breaks and numbering Keep these points in mind: You can set options for page breaks and page numbering when you add a layout part or change a part definition. (When you add a part, you automatically see the Part Definition dialog box.
6-30 FileMaker Pro User’s Guide 3. Click Done. FileMaker Pro moves all the fields and objects in the part and maintains its proportions. Important Deleting a part using the Part Setup dialog box can’t be undone. 1. In Layout mode, choose Layouts menu > Part Setup. Note To quickly move a part directly on the layout, Shiftdrag the part label (or the dotted line that marks the bottom of the part). 2. In the Part Setup dialog box, select the part to delete, then click Delete.
Chapter 7 Customizing layouts After creating a layout, you can change its appearance or the way the layout works.
7-2 FileMaker Pro User’s Guide To Do this Add borders to fields and set their attributes Select any combination of Top, Bottom, Left, or Right. From the format list, choose Borders and choose a color, pattern, and line width from the popup palettes. Add text baselines and Select Text baselines. From the format list, choose set their attributes Baselines, then choose a color, pattern, and line width from the popup palettes.
Customizing layouts 7-3 2. In the Define Value Lists dialog box, click New. Keep these points in mind: • Scroll bars are always displayed if you set the field borders option for the right side of the field. Otherwise, they display only when you tab into the field. See “Adding borders, fill, and baselines to fields” on page 71.
7-4 FileMaker Pro User’s Guide 4. Define the value list: To Do this Define static values for the value list Select Use custom values, then type each value on a separate line, in the order you want them to appear. Press Enter (Windows) or Return (Mac OS) to separate each value. Create values Select Use values from field.
Customizing layouts To change, duplicate, or delete a value list: 1. Choose File menu > Define Value Lists. 2. In the Define Value Lists dialog box: To Do this Change the values in a value list In the list of value list names, select the value or how the values in a dynamic list, then click Edit. In the Edit Value List value list are generated dialog box, make changes.Then, click OK. Duplicate a value list In the list of names, select the value list, then click Duplicate.
7-6 FileMaker Pro User’s Guide In the above example, you would perform the following basic steps: Name of field selected on a layout 1. Define a value list for Product Name with the Use values from field and Only related values options. 2. Define a relationship to the same database file (a selfjoin) and Select or define a value list Choose how to display the value list specify Category as the match field. (See “Defining relationships for relational databases and lookups” on page 1210.) 3.
Customizing layouts 7-7 Formatting repeating fields Checkboxes Radio buttons If you define a field as a repeating field, you can format the field to display only a certain number of the repetitions, even though the information for all the repetitions is stored in the database. See “About repeating fields” on page 511. Pop-up menu 1. In Layout mode, select one or more repeating fields, then choose Pop-up list 4.
7-8 FileMaker Pro User’s Guide Allowing or preventing entry into fields You can allow or prevent entry into a field in Browse and Find modes. For example, you can restrict entry into a field containing a serialized number, like an invoice number, so the field can’t be modified.
Customizing layouts 2. In the Set Tab Order dialog box, specify the options you want to use: To Do this Reorder the tab order for individual fields Select Edit tab order. Click the field whose order you want to change and type a new number for the arrow. The number you replace is swapped with the number you type. Define a new tab order Select Create new tab order and click the fields in the for all fields new order. FileMaker Pro inserts numbers in that order in the arrows.
7-10 FileMaker Pro User’s Guide Customizing the appearance of a layout You can enhance the design of a layout in a number of ways, including: • adding text outside of fields • using the drawing tools to add lines, rectangles, or other shapes • adding a graphic or QuickTime movie See “Working with the layout tools” on page 611 for more information about layout tools.
Customizing layouts • Depending on what layout part the text is in, it appears in different places on your layout in Browse mode or Preview mode (for example, once for each record, only at the top of the report, and so on). See “About layout parts” on page 625. • To eliminate blank spaces when printing, see “About removing blank space from printed data” on page 722.
7-12 FileMaker Pro User’s Guide Formatting text Making text bold, italic, or setting other styles You can specify how text (both in and outside of fields) appears on your layout. You control: There are several ways to format text. Select the text you want to format, then: • the character attributes of the text, including font, font size, style, and color • Choose text formatting (like a Font or Style) from a submenu on the Format menu.
Customizing layouts Indent text 7-13 Set line spacing and change the units of measure Choose text attributes Select one or more styles Align text Set tabs Specify paragraph and tab settings (see the next section) 3. Click OK. For more information about setting up layouts for web publishing, see “Setting up browser views” on page 1210. 5. To specify tab settings for the paragraph, click Tabs. 6. In the Tabs dialog box, specify tab settings.
7-14 FileMaker Pro User’s Guide Drawing lines and shapes Use the drawing tools in the tool panel or Tools toolbar (choose View menu > Toolbars > Tools) to draw lines and shapes to emphasize parts of your layout. FileMaker Pro draws the object with the default line width, pen color, and pattern, and it fills the object with the current fill color and pattern (for all objects except lines). You can change these attributes before or after you draw the object.
Customizing layouts 7-15 Or, to specify attributes for objects you add later, start with no objects selected. • To copy the attributes of one object to other objects, use the Format Painter tool. For more information, see FileMaker Pro Help. 2. Choose colors, patterns, line or border widths, and object effects from the palettes in the status area. • For fields, palette settings replace Field Border dialog box settings. See “Adding borders, fill, and baselines to fields” on page 71.
7-16 FileMaker Pro User’s Guide • If you want to use an object effect on a field, try selecting the effect before placing the field on the layout. Otherwise, the effect might clip part of the text in the field. • The width of the effect depends on the width of the object’s border as specified by the pen width (unless the object has no border, in which case the object effect is drawn with a 1 point line). The effect’s color and pattern depend on the fill color and pattern of the selected object or field.
Customizing layouts Formatting graphics on a layout 7-17 Arranging objects In Layout mode, you can format graphics you’ve pasted or imported onto a layout in the same way you format graphic data in a container field. For more information, see “Specifying formats for fields containing graphics” on page 624.
7-18 FileMaker Pro User’s Guide Keep these points in mind: To move the object Choose • When you ungroup a group that contains other groups, the One layer forward Bring Forward Behind all other objects Send to Back One layer back Send Backward subgroups stay grouped until you ungroup them. • If you include a locked object in the group, the resulting grouped object is also locked. • To edit text that’s part of a group, doubleclick the text.
Customizing layouts 7-19 Using tools to precisely position objects Use the Size palette, graphic rulers, ruler grid lines, Tsquares, and object grids to precisely size, reshape, position, and align objects. (For more information about moving objects on a layout, see “Moving objects on a layout” on page 614.) Objects before distributing space Objects after distributing space vertically and aligning left sides 1.
7-20 FileMaker Pro User’s Guide If you can’t type a value, that field doesn’t make sense for the selection (for example, a line doesn’t have a height), or the selection is locked. Click to change the unit of measure 4. Press Enter, or to move to another field in the Size palette, press Tab or Return (Mac OS). Ruler lines The Size palette floats above the window, so you can leave it open as you work.
Customizing layouts 7-21 Using the object grids Specifying page margins Use object grids to precisely control the placement of objects on the layout. When object grids are on, each object on the layout “snaps to” its own invisible grid (which may be different from another object’s grid). When you move or resize an object, it snapsto the nearest grid coordinate. New objects are created aligning to the “master” grid. You can specify different margins for each layout.
7-22 FileMaker Pro User’s Guide 5. Click OK. 6. Choose View menu > Preview Mode to check the margins. Keep these points in mind: • In Layout mode, choose Layouts menu > Set Rulers to change the Margins— objects in this area won’t print unit of measure for margins. See “Using graphic rulers and ruler gridlines” on page 720. • If you select Print in columns for a layout and then specify page margins, the columns resize to fit within the new margins.
Customizing layouts • Objects—including fields—slide left (or up) corresponding to the Printing without sliding objects amount of space that the fields to the left of (or above) the objects shrink. Tour Catalog Ship/Destination Tour length Wholesale price Season Notes Grand Monarch Alaska 7 nights $795 Summer Autumn Winter All year Spring Glacier route between Vancouver and Anchorage. Includes Columbia Glacier, College Fjord, Ketchikan, Juneau, Skagway, Sitka, and Valdez. Optional tour to Denali Park.
7-24 FileMaker Pro User’s Guide • When you slide objects or parts, FileMaker Pro prints the objects relative to each other, not precisely as you placed them on your layout. 3. In the Set Sliding/Printing dialog box, select the sliding options you want. • If you leave blank space on a layout, FileMaker Pro keeps that Select this option space. For example, if you create a body with one inch of space below the lowest object, FileMaker Pro leaves one inch below the lowest object when it shrinks the body.
Customizing layouts Keeping objects from printing You can keep objects on a layout from printing. For example: • Prevent buttons on a report layout from printing when you print the report. • Place instructions on a layout to be read during data entry, but not printed when that layout is printed. To keep objects from printing: 1. In Layout mode, select the object or objects that you don’t want to print. 2. Choose Format menu > Sliding/Printing. 3.
Chapter 8 Working with related files There are times when one database file doesn’t suit all your data management needs. Perhaps you have data in one file that you want to use in another file. Or you’ve tried to expand a file by adding several fields to it, and now the file’s subject has become unclear. Or you have the same values in several files, and you’re constantly updating them to keep them all the same. You can access data from other database files by using relational databases and lookups.
8-2 FileMaker Pro User’s Guide Relational database terminology Before you begin, you should understand the following terms for relational databases and lookups. These terms are illustrated in the sections that follow. This term Means Master file For relational databases, the file that accesses and displays data from another file. This term Means Related field A field in the related file that contains data you want to access and work with in the master file.
Working with related files For example, a travel agency might store trip information in a Trip file, then use it with client information that’s in a Client file and with billing information that’s in an Invoice file.
8-4 FileMaker Pro User’s Guide When the related file contains one matching record for each record in the master file, place related fields directly on the layout and not in a portal. Also place related fields directly on the layout when you want to work with only the first matching record that’s accessed (in sorted or unsorted order).
Working with related files • Define a lookup, to copy data from one related record for each record in the master file (a onetoone correspondence). For example, use a lookup to copy the current price of a product into a Line Items file. (Data copied to the master file doesn’t automatically change when the data in the related file changes.
8-6 FileMaker Pro User’s Guide • You can increase the number of possible matching records in either the master file or related file by entering all possible matching values in the match field (sometimes called a multi-key field or complex key field). Suppose you want to display all the sales contracts obtained by each employee, including those obtained by teams of employees, in a portal in the master file.
Working with related files • To copy data into a second field that uses the same match fields— for example, to copy a name and telephone number based on a matching client identification number—define a lookup for the second field, and use the same relationship as for the first field. Related file Master file Client ID Client ID Relationship 42.83.91.04 • Maintain files that already contain lookups, when you don’t want to change the files to a relational database.
8-8 FileMaker Pro User’s Guide - Information to hold? - Database files? - Fields? - Common data? 3. Determine the match field or fields for each file, and circle each one. Each relationship uses one match field in the master file and one match field in the related file. Match fields are also used to determine whether a new record should be added to the file. In an efficient database system, this field often (but not always) contains a value unique to each record.
Working with related files Client ID Client Name Street Determining relationships between database files shows you where you can use data that’s stored in one file in another file. Route ID Origin Destination Trip ID Trip Name City Route ID Postal Code Origin Phone Destination Trip ID Trip Name Client file 8-9 Route file Trip file 5. Determine the relationships between the files. Draw a line from each match field in the master file to the corresponding match field in the related file.
8-10 FileMaker Pro User’s Guide Important After you create the files for a relational database or a lookup, be sure there are no other files with the same filenames on your computer or network. To duplicate the files or create similar filenames, duplicate each file separately (which creates a unique name for each copy). Store backup files on a removable disk, and remove the disk. Use a compression or archiving utility to make the files unavailable as FileMaker Pro files.
Working with related files Type a relationship name To 8-11 Select Add records to the related file by entering data Allow creation of related records into related fields in the master file. (See “Adding and duplicating records” on page 24.) Select a match field in the master file Select a match field in the related file If the related file is locked or writeprotected, or users don’t have access privileges to create records, records are not added to the related file.
8-12 FileMaker Pro User’s Guide Changing relationships 3. To edit the relationship, make your changes in the Edit Relationship dialog box, click OK, then click Done. When you change a relationship, your changes affect which records are accessed in the related file and displayed in records of the master file. To Do this Rename a relationship For Relationship Name, type a new name.
Working with related files 2. Define a formula for the field that includes an aggregate function for the type of summary calculation you want to perform. (See “Aggregate functions” on page 127.) For example, for a Total field, which calculates the total of values in the related field Price (which is in a portal and uses the relationship Line Items), define the following formula: To Do this Prevent null (empty) data in the Select Don’t copy contents if empty.
8-14 FileMaker Pro User’s Guide Accessing related data from a third file There may be times when you need to access values from a field whose values are accessed from another file. You can’t directly access a field in a file several relationships away that’s already used as a related field in another file. However, you can define intermediate calculation fields to access those fields that are more than one relationship away.
Working with related files Creating many-to-many relationships In a onetoone relationship, one record in the master file is related to one record in the related file. In a onetomany relationship, one record in the master file is related to more than one record in the related file.
Chapter 9 Protecting databases with passwords and groups When you store confidential information in your database files or want to restrict users from modifying layouts or other database elements, you need a security system to protect your file. This helps ensure that records, fields, layouts, or scripts aren’t inadvertently deleted or changed. This chapter explains how to protect your FileMaker Pro files by setting access privileges for passwords and groups. You’ll learn about: 3.
9-2 FileMaker Pro User’s Guide Select To let users with this password Choose To Create records Create records and enter data in them. This also enables users to modify value lists in Browse mode if the Include Edit item... option is enabled. None Disable all menu commands for the current file (except common system commands and executing scripts). Edit records Change the information in (all) records. This also enables users to modify value lists in Browse mode if the Include Edit item...
Protecting databases with passwords and groups • You can define a blank password that gives all users limited access to a file. When the file is opened, anyone can press Enter or Return to access the file. This option can be used to allow limited access to the file without needing to know or enter a password. When accessing a file with a blank password on the Web, the blank password is automatically used. This means all web users have access to the privileges assigned to the Blank password.
9-4 FileMaker Pro User’s Guide Click to associate passwords with a group Groups defined in the file Click to define or change passwords Type a new group name 5. In the Access Privileges dialog box, select the group to set additional privileges. Master password 7. Set the access privileges for specific layouts and fields by clicking the bullets next to them. To make a field or layout Do this Accessible (available for editing) Click the bullet next to the field or layout until it is black ( ).
Protecting databases with passwords and groups • In the previous example (the Access privileges overview for the Marketing group), users who enter the Car password can view and edit the records using the Product List, Price List, and Advertising Cost layouts. They can view, but not edit data on the Current Inventory layout and cannot view or edit records using the Margin Report layout. Additionally, they can’t view or edit the Cost and No.
9-6 FileMaker Pro User’s Guide Passwords and groups: a comparison Passwords and groups are related. Passwords limit what users can do and groups limit the layouts and fields they can see. You specify access privileges for both passwords and groups. • For passwords, specify access privileges that limit a user’s activities with the entire file (all the records, fields, layouts, etc.). For example, one password might let users create and edit records, but another might only let them browse records.
Chapter 10 Creating scripts to automate tasks FileMaker Pro includes the ScriptMaker™ feature, which you can use to automate many tasks, including switching to another layout, switching to another mode, and finding, sorting, and printing records. For example, when you click the Letter button on the Client Entry layout, a script displays the Letter layout. Then the script switches to Preview mode and pauses so you can see what the letter looks like when it prints.
10-2 FileMaker Pro User’s Guide • importing data from the same source • dialing phone numbers You can perform additional scripts, called subscripts, within a script. Subscripts make it easy to break a complex task into small tasks. For example, you can find customers with a balance due with one script, and then print form letters requesting payment with another script. The first script contains a command that performs the second script (the subscript).
Creating scripts to automate tasks Creating scripts: an overview Whether your FileMaker Pro scripts are simple or complex, you will find that it is easier to create them if you: • plan the script before you define it. • perform certain operations, like Find requests and Sort order, before you open ScriptMaker, thus making it easier to store the parameters for these requests. See “Storing settings before creating a script” on page 124 for more information.
10-4 FileMaker Pro User’s Guide Tip Save a clone (or copy) of your database, and then define and test your script in it to preserve the original data. After testing the script, import data from the original file into the clone, or use the Import Script feature to import this script into your database. See “Importing scripts” on page 1211, for more information on this feature.
Creating scripts to automate tasks The options in this dialog box are described in more detail in the following sections. To Do this Add a subscript Select Perform Script in the Available Steps list, and then click Move. Select the Perform sub-scripts option, and then choose the subscript from the popup menu. Choose External Script if the subscript is in a different file. Add a pause in the script Select Pause/Resume Script in the Available Steps list, click Move, and then specify the options.
10-6 FileMaker Pro User’s Guide About ScriptMaker steps A step is a FileMaker Pro command that you use in a script. Steps are similar to the commands you access through FileMaker Pro menus. For example, you can create a record by choosing New Record from the Records menu, or you can perform a script that contains the New Record/Request step.
Creating scripts to automate tasks 10-7 Use this step To Use this step To Go to Previous Field Move to the previous field on the current layout Paste Paste the contents of the Clipboard into a field Enter Browse Mode Switch to Browse mode Clear Enter Find Mode Switch to Find mode Delete the contents of a field without copying the contents to the Clipboard Enter Preview Mode Switch to Preview mode Select All Select the entire contents of a field Sort, find, and print script steps Fields
10-8 FileMaker Pro User’s Guide Use this step To Windows script steps Insert Object Insert an embedded or linked object into a container field Use this step To Freeze Window Stop updating the window (hide actions from users) Refresh Window Redraw the screen, or resume updating after Freeze Window Scroll Window Scroll the window up, down, or to the current selection Toggle Window Hide (Mac OS) or change the size of the window Toggle Status Area Show, hide, or lock the status area Toggle Te
Creating scripts to automate tasks 10-9 Spelling script steps Miscellaneous script steps Use this step To Use this step To Check Selection Check the spelling of the current text selection Show Message Display an alert message Check Record Check the spelling of text in the current record Show Custom Dialog Check Found Set Check the spelling of all fields in all records in the found set Define a custom dialog box that may include user input fields Allow Toolbars Hide the FileMaker Pro toolb
10-10 FileMaker Pro User’s Guide Changing scripts 1. Choose Scripts menu > ScriptMaker. 2. In the Define Scripts dialog box, select a script name. 3. In the Script Definition dialog box, change the script steps, and then click OK. To Do this Add steps Select the steps in the Available Steps list, and then click Move. Select options for the step, if they’re available.
Creating scripts to automate tasks Importing scripts FileMaker Pro allows you to import scripts from other FileMaker Pro databases. 10-11 • When importing a script that references a relationship: • There must be an identically named relationship in the source and destination file. • The field names and types must be the same. Many scripts reference fields (local and related), layouts, records, and other scripts (local and in external files).
10-12 FileMaker Pro User’s Guide 3. To add or delete a script from the menu, select the script, then select or deselect Include in menu. Defining buttons Use the following steps to create a button labeled with text. Scripts with checkmarks will appear in the Scripts menu. 4. Click Done. Note To create another type of button (for example, a circle with a graphic), see FileMaker Pro Help. Using buttons with scripts 1. If you’re defining a button that performs an entire script, create the script.
Creating scripts to automate tasks 10-13 To Do this in Layout mode Change the appearance of a button See “Setting color, pattern, line width, and object effects,” on page 714. Change a button label See “Formatting text,” on page 712. Copy a button When you copy a button, you copy the object and the button definition. If you copy a button from another file, change the button definition if fields, layouts, or scripts don’t match. See “Copying, duplicating, and deleting objects,” on page 613.
10-14 FileMaker Pro User’s Guide The Seminar file contains records of clients who register for a seminar. Each client has a unique identification code, the Client ID field, which is a concatenation of the clients’ last name and phone number. Some records contain the same identification number— these are the duplicate records you want to find. 5. Define the script. In ScriptMaker, define the Find Duplicates script.
Creating scripts to automate tasks Record 5 Mark Record 4 Mark Record 3 Record 1 Client ID aaa Mark Record 2 Mark Client ID aaa Global aaa Mark X Global aaa Global aaa Global aaa Global aaa • If the values don’t match, FileMaker Pro copies the ClientID value into Global. It doesn’t change the Mark field. 4. The script repeats step 3 until it reaches the last record in the file.
Chapter 11 Using formulas and functions This chapter: • introduces formulas and functions • lists the places you can use formulas and functions • shows the components of formulas • describes operators you can use in formulas • gives a brief description of all functions See Help for more detail and examples for each function, and for information on some newer logical, design, and status functions. About formulas A formula is a specific operation on one or more values in the database.
11-2 FileMaker Pro User’s Guide Expressions A formula contains one or more expressions. An expression is a value or any computation that produces a value. Expressions can be combined to produce other expressions. Type of expression Example Text constant "London" Number constant 2.15 Field reference TaxRate Function Length(ShipToAddress) Combination of expressions ((Total–Discount)*TaxRate)/100 A constant is a fixed value that’s part of the formula and doesn’t change from record to record.
Using formulas and functions 11-3 Operators Comparison operators You combine expressions using operators, symbols that determine which operation to perform on the expressions. You place operators between the expressions you want to perform the operation on. Comparison operators compare two expressions and return either true or false. (True and False are Boolean results.) Arithmetically, a result of true equals 1 and a result of false equals 0.
11-4 FileMaker Pro User’s Guide Logical operators Text operators Use logical operators to include conditions in a calculation. Use the following text operators with text expressions. (Double quotation marks enclose text constants.) Operator Definition Example AND True only when both of two values are true. ApplicationReceived= ”Y” AND FeePaid>0 OR True when either of two values is CurrentBalance <= 0 OR true.
Using formulas and functions About functions A function is a predefined, named formula that performs a specific calculation and returns a single, specific value. You type the function, and FileMaker Pro performs the calculation it represents.
11-6 FileMaker Pro User’s Guide Syntax Definition Syntax Definition Length (text) Returns the number of characters in text. Trim (text) Lower (text) Returns text as lowercase. Returns text without leading and trailing spaces. Middle (text, start, size) Returns characters in text, counting from the position of start, through the number of characters in size. Upper (text) Returns text as uppercase. WordCount (text) Returns the number of words in text.
Using formulas and functions Date functions Use these functions when date is a date field holding a date, or a calculation or expression with a date result. Example: Year (Date Of Birth) returns 1962 when the Date of Birth field holds 1/1/1962. Important To avoid confusion when using dates, always use four digit years. For more information on how FileMaker Pro handles Year 2000 issues, see www.filemaker.com.
11-8 FileMaker Pro User’s Guide See below for examples of each of these situations. Example 3 This function Does this Average (field...) Averages the numbers, dates, or times in the (field...) parameter(s) you specify Count (field...) Returns the number of items [the (field...) parameter(s) you specify], which are not empty Max (field...) Returns the largest number or time or the latest date in the (field...) parameter(s) you specify Min (field...
Using formulas and functions Important To generate subsummary values, you must sort the database by the break field. Syntax Definition GetSummary (summary field, Returns the subsummary value of summary break field) field for the current group of records when records are sorted by break field; otherwise, returns an empty result. GetSummary (summary field, Returns the grand summary value of summary summary field) field for the current found set of records. Item Total Tax Rate 5.00 17.00 82.
11-10 FileMaker Pro User’s Guide Trigonometric functions Syntax Definition Syntax Atan (number) Returns the trigonometric arc (inverse) tangent of number. The arc tangent is the angle, in radians, whose tangent equals number. Cos (number) Returns the cosine of the angle (in radians) of number. Case (test1, result1 [, test2, Evaluates test(s) to produce a result. When test1 is result2, default result]...) true (a nonzero value), returns result1; when test1 is false, evaluates test2.
Using formulas and functions If you use status functions in defined calculation fields, the calculation results must be unstored. Otherwise, the calculation does not update when the status changes. See chapter 5, “About storage and indexing options.” The functions below appear in the list of functions in the Specify Calculation dialog box when you choose View status functions or View all by type. When you view all functions by name, you see Status (status flag), which is a temporary placeholder.
11-12 FileMaker Pro User’s Guide Syntax Definition Syntax Definition Status (CurrentPrinterName) Returns the identification of the current default printer, the driver name, and the name of the printer port (Windows) or printer (Mac OS 9 or earlier). Not supported on Mac OS X. Status (CurrentScreenWidth) Returns the number of pixels displayed horizontally on the screen on which the current file is open. Status (CurrentRecordCount) Returns the number of records in a file.
Using formulas and functions For example, LayoutNames (“Clients”) always returns the names of the layouts in the Clients file. If you have a field named File, LayoutNames (File) returns the names of the layouts in the Clients file when you type Clients in the File field. Syntax Definition DatabaseNames Returns the names of the currently opened databases. (Uses no parameters.) FieldBounds (database name, layout name, field name) Returns the location and size of a specified field.
11-14 FileMaker Pro User’s Guide Syntax Definition External ("WebClientIP", 0) Returns the IP (Internet protocol) address of the Web user whose HTTP request is currently being processed by FileMaker Pro Web Companion External ("Web ClientName", 0) Returns the value that the Web user types for user name in the Web browser password dialog box External ("Web ClientType", 0) Returns the name and version of the Web browser being used by the Web user External ("WebToHTML", field name) External ("WebT
Part 3 Sharing and exchanging data
Chapter 12 Importing and exporting data You can exchange information with FileMaker Pro files or with files created in other applications. This chapter shows you how to: • import data into a file • replace records in a file with records in another file • update records in a file with records in another file • convert documents from other applications to FileMaker Pro files • export data for use with other applications To exchange data via ODBC, see chapter 12, “Using ODBC with FileMaker Pro.
12-2 FileMaker Pro User’s Guide Importing data into FileMaker Pro You can import data into an existing FileMaker Pro file from another FileMaker Pro file, or from documents created in another application (See “Importing data into an existing file” on page 122.) You can also convert documents from another application into a new FileMaker Pro file. (See page 126.) The file or document you import records from is the source file. The file you import records to is the destination file.
Importing and exporting data Match fields must uniquely identify each entity in your database. For example, in a database of people, you could use Social Security Number, or Last Name, First Name, and Phone Number. Last Name alone might identify more than one person, so it isn’t a good match field. You also specify the fields you want to import.
12-4 FileMaker Pro User’s Guide • If you’re updating records, make sure the found set contains only the records you want to update. Records outside the found set will not be updated, even if match field data matches. 5. In Browse mode, choose File menu > Import Records > File. 6. In the Open File dialog box, to see all the files in the current folder that you can import: for Files of type (Windows) or Show (Mac OS), choose All Files. To narrow the choices, choose a file type from the list. 7.
Importing and exporting data Data on the left that is not aligned with a field on the right will not import. If a field name on the right is dimmed, it’s a calculation, summary, or global field that can’t accept imported data. To Do this Reorder all fields Choose an option from the View By list. To list the fields by: in the Fields in list at 1 names that match, choose matching names.
12-6 FileMaker Pro User’s Guide • If you replace or update records, be sure your records are correct before discarding the backup copy of the file. 6. In the next dialog box, type a name for the new file, select a location, then click Save. • FileMaker Pro doesn’t validate imported data. If you’re converting a Microsoft Excel spreadsheet, FileMaker Pro scans the incoming data to assign an appropriate field type to each column.
Importing and exporting data 12-7 Relationship list FileMaker Pro exports these fields Select fields from this list Type a name for the exported file Choose a file type that the target application supports 5. Choose a file type from the Save as type list (Windows) or Type list (Mac OS), then click Save. 6. In the Specify Field Order For Export dialog box, set the field order as needed. Choose a character set Choose a formatting option 7.
12-8 FileMaker Pro User’s Guide • You can export data in container fields to FileMaker Pro format. • Exporting repeating field values to SYLK, WKS, or DBF formats 3. In the Export Records to File dialog box, type a name, then choose is documented in Help. Choose Help menu > Contents and Index, click the Index tab, and type exporting,data. 4. Choose a file type from the Save as type list (Windows) or Type list (Mac OS), then click Save. Exporting subsummary data 5.
Chapter 13 Sharing databases on a network FileMaker Pro contains builtin support to allow you to share files over a network. By sharing files, you can work simultaneously with others in your work group, and save disk space by keeping files in a central location. FileMaker Pro supports sharing of up to 10 files with up to 10 concurrent users. In certain instances, you can share a single FileMaker Pro file with up to 25 other concurrent users, with this number dropping as you share more files.
13-2 FileMaker Pro User’s Guide When you share files between platforms, you may see differences in font mapping, alignment of layout objects, and character set mapping. • (Mac OS) You don’t have to turn on File Sharing (in the Sharing � Setup control panel) to share FileMaker Pro files from a � Mac OSbased computer.
Sharing databases on a network • FileMaker Pro saves the host’s sort order, find requests, and print setup (Windows) or page setup (Mac OS). If you’re a guest, you can save your settings by defining a script. See “Creating scripts to automate tasks” on page 101. • When you share a file with system formats that are different from the settings on your computer, you can choose which formats to use. See FileMaker Pro Help.
13-4 FileMaker Pro User’s Guide 4. In the File Sharing dialog box, select either Multi-User or Multi-User (Hidden). Note If Multi-User and Multi-User (Hidden) are dimmed in the File Sharing dialog box, FileMaker Pro is unable to access the network. An explanation appears below the Multi-User button. You can also get an explanation by choosing Open from the File menu, then clicking Hosts. Use the MultiUser option to host a file and make its name display in the Hosts dialog box on guests’ computers.
Sharing databases on a network Guests see a message asking them to close the file. If guests click Close Now, FileMaker Pro closes the file. If the guests don’t respond to the message and the file can be closed safely, FileMaker Pro closes it in 30 seconds.
13-6 FileMaker Pro User’s Guide If you select a FileMaker Server host (instead of a shared file), you � will be able to remotely administer the Server. See the � FileMaker Server documentation for information.� Keep these points in mind:� • Close your connection to a shared file if the host asks, or if you aren’t using the file. • If some menu commands, layouts, or fields are dimmed, you may have limited access to the file. See “Protecting databases with passwords and groups” on page 91.
Chapter 14 Publishing databases on the Web With FileMaker Pro, you can make your data available on the Web. For example, you can publish an events calendar, so that customers can access the information using a web browser.
14-2 FileMaker Pro User’s Guide This term Means Host computer� In FileMaker Pro web publishing, a web server running FileMaker Pro with the Web Companion enabled. Your published databases must be open on the host computer. Internet Protocol (IP) address A unique address for each computer connecting to the Internet or an intranet. Web pages are sent from one IP address to another—first a web browser requests specific pages, then the server application delivers the requested page to the browser.
Publishing databases on the Web There are two additional ways to publish your data using FileMaker Pro: Type the IP address in the browser window • For more control over the appearance and functionality of your published database, use the features available in the FileMaker Developer software. For example, you can create custom web pages that interactively enter web users’ names into a database field. For information about FileMaker Developer, choose Help menu > FileMaker on the Web.
14-4 FileMaker Pro User’s Guide What you need to publish databases on the Web To publish databases using Instant Web Publishing you need: • a Windows– or Mac OS–based computer running FileMaker Pro • FileMaker Pro Web Companion must be installed.
Publishing databases on the Web The host computer should have a static (permanent) IP address. However, if you connect to the Internet using a modem connection to an Internet service provider (ISP), your IP address could be dynamically allocated (it is different each time you connect). A dynamic IP address makes it more difficult for users to locate your databases. • To publish your database within a company or workgroup, the host computer should have a fulltime connection to an intranet using TCP/IP.
14-6 FileMaker Pro User’s Guide • To prevent a published database from displaying on the builtin home page, rename the database to include an underscore character at the end of the filename, before any filename extension (for example, Orders_ or Orders_.fp5). If you change the filename, you may need to change references to the file in relationships and scripts. To create a custom home page, you need software for editing HTML, like a text editor or web page authoring application.
Publishing databases on the Web Repeat the following steps for each database you publish: 1. Enable Web Companion Sharing. (See “Enabling Web Companion sharing” on page 1210.) 14-7 Configuring FileMaker Pro Web Companion Search and Sort pages. (See “Setting up browser views” on page 1210.) After you enable the Web Companion, verify that the configuration settings are correct. Since the default values are appropriate for most uses, you may not need to change these settings. 3.
14-8 FileMaker Pro User’s Guide Enabling Instant Web Publishing To Do this Publish databases� Be sure Enable Instant Web Publishing is selected in the Web Companion Configuration dialog box. Stop publishing all databases Clear Enable Instant Web Publishing. Stop publishing one database Disable Web Companion Sharing in that database. See “Enabling Web Companion sharing” on page 1210.
Publishing databases on the Web 14-9 • use HTTP Put and Get commands to upload or download database files to and from the Web folder (inside the FileMaker Pro folder). In addition, you can upload any file to the Web folder. For information about HTTP commands, see your web browser documentation or an HTML reference. To specify the computers that can access your databases, select Restrict access to IP address(es), then type one or more IP addresses. For example, you can specify that only address 12.34.56.
14-10 FileMaker Pro User’s Guide Enabling Web Companion sharing Setting up browser views For each database you want to publish on the Web: In a web browser, users can see different pages, or views, of your database: 1. Open the database. 2. Choose File menu > Sharing. You must have the Export records access privilege to open the File Sharing dialog box. If you can’t open the dialog box, reopen the database with a password that provides the Export records privilege.
Publishing databases on the Web Choosing a web style FileMaker Pro Instant Web Publishing includes web styles that determine the appearance of your database in a browser. For example, you can choose the Lavender style to display titles and buttons in a purple color scheme. You can also choose styles specifically designed for searching for records, or for creating records. Web style Renders layouts Comments Blue and Gold 1 Yes� Similar to the style used in FileMaker Pro 4.
14-12 FileMaker Pro User’s Guide About layout rendering Fern Green style in a browser window Most web styles render layouts—they display your layouts in a web browser almost as they appear in a FileMaker Pro window. Web styles can render layouts in Form View, New Record, and Edit Record pages. (See “About browser views for web publishing” on page 1214.) This style doesn’t render the layout. For example, the logo doesn’t appear, and the field names and fields display vertically.
Publishing databases on the Web Keep these points in mind: • The layout you choose for Form View is also used for New Record and Edit Record pages. See “About browser views for web publishing” on page 1214. To Select Let users define how data is sorted User defines sorting by specified fields in the browser. Click Specify to choose the fields, then click OK in the Specify Sort dialog box.
14-14 FileMaker Pro User’s Guide • Test your published database in different operating systems and browsers. About browser views for web publishing • Check to be sure unauthorized users can’t access or modify your The following sections describe the pages that are available in FileMaker Pro Instant Web Publishing. data. Tip You can test web publishing features in FileMaker Pro without connecting to the Internet or an intranet. For more information, see FileMaker Pro Help.
Publishing databases on the Web Browsing records in Table View The Table View page lists multiple records. Each row displays a record, and each column displays a field. Click to display the first record in Form View Type the range of records you want to view (like 1-5), then click the arrow Click a record number to display the record in Form View Table View in a browser Searching for records The Search page provides options for finding information in your database.
14-16 FileMaker Pro User’s Guide Sorting records The Sort page provides options for changing the record order. Sorting records in a browser Click to sort records Click to reset the sort order Click to return to Table View or Form View without sorting records Select field names for the first, second, third, and fourth sorts Creating records The New Record page displays a form for entering data. Note There isn’t a separate web page for deleting a record.
Publishing databases on the Web Editing records The Edit Record page displays a form for changing existing data in a record.
Chapter 15 Using ODBC with FileMaker Pro This chapter explains how to: ODBC terminology • set up a FileMaker Pro database to share data via ODBC • import data into an existing FileMaker Pro database using ODBC Before working with ODBC, it’s useful to understand the following terms. About ODBC Open Database Connectivity (ODBC) is an application programming interface (API) that enables applications to access data from many different database management systems.
15-2 FileMaker Pro User’s Guide ODBC support in FileMaker Pro You can use the ODBC support in FileMaker Pro to: • work with FileMaker Pro data from ODBCcompliant applications other ODBCcompliant applications. Enable the Local Data Access Companion to share a FileMaker Pro file on the same computer. Enable the Remote Data Access Companion to share the FileMaker Pro file across a TCP/IP network.
Using ODBC with FileMaker Pro • Enable Remote Data Access Companion to share this FileMaker Pro database with ODBCcompliant applications remotely across a TCP/ IP network. 5. Verify that the file was opened using a password that allows you to export records. Important Each file must remain open for client applications to access the data. The FileMaker Pro data is ready to be accessed by an ODBC compliant client application through the FileMaker Pro ODBC driver.
15-4 FileMaker Pro User’s Guide To configure the ODBC control panel to access FileMaker Pro data via ODBC: 1. Open the ODBC control panel (named ODBC Data Sources (32bit) in Windows and ODBC Setup PPC in the Mac OS). 2. In the User DSN tab, click Add to configure a new data source.
Using ODBC with FileMaker Pro Importing data from other data sources Using ODBC, you can import records into an existing database or a new FileMaker Pro file by opening an ODBC data source (like Oracle or Microsoft Access databases) directly. The FileMaker Pro SQL query builder makes it easy to construct queries that can search a data source or DBMS, fetch specific records, and import the resulting records into a FileMaker Pro database.
15-6 FileMaker Pro User’s Guide Connecting to an ODBC data source from FileMaker Pro Specify advanced settings After you’ve specified and configured the data source, you can open your FileMaker Pro database and import ODBC data. Specify the data source name and description To select the ODBC data source: 1. Open the FileMaker Pro database file you’ll import data into. Select to import column names 2. In Browse mode, choose File menu > Import Records. 3. Choose the file import format.
Using ODBC with FileMaker Pro 15-7 Specify the columns from each table to insert into the SQL query Click to add choices into the SQL query below As you make choices in each tab, the SQL query is automatically generated Select an ODBC data source Click to execute the SQL query 5. If appropriate, enter the user name and password for the data source you selected, and click OK. 2. Select a column to insert into your SQL query and click Insert into Building a SQL query in FileMaker Pro SQL Query.
15-8 FileMaker Pro User’s Guide Select Matching Names if column names match FileMaker Pro field names Creating a SQL join Align columns with field names Choose a mapping option Using the WHERE SQL statement 5. To sort records before importing, click the ORDER BY tab, then specify the name of the column to sort by and whether the sort should be ascending or descending. 6. When you’re finished constructing the query, click Execute, then map the ODBC columns to FileMaker Pro fields.
Using ODBC with FileMaker Pro Configuring the ODBC control panel for the Text driver 15-9 Choose Guess Definition to retrieve column names 1. In the User DSN tab of the ODBC control panel (named ODBC Data Sources (32bit) in Windows and ODBC Setup PPC in the Mac OS), click Add. 2. Select the ODBC driver for the data source you are importing from, and click Finish. Click Define to specify ODBC tables Windows: Choose FileMaker Text Driver. Mac OS: Choose FileMaker 3.11 Text PPC. 3.
15-10 FileMaker Pro User’s Guide Click Guess to insert column names 3. For column information, click the Guess button. The ODBC driver retrieves the column names from the specified table. Click Guess to insert column names Select to retrieve column names from the ODBC table Select to retrieve column names from the ODBC table 6. Select the Date_Sold column and verify that the Type and Mask values are correct. 4. Specify the information for the Salespeople table.
Using ODBC with FileMaker Pro 15-11 3. Select the Salesperson ID column, then click Insert into SQL Query. 4. Insert the following columns by doubleclicking the column name: Salesperson, Sales_Manager, and Sales_Region. 5. Click Execute. The Import Mapping dialog box appears. For more Select the ODBC data source you previously configured information on importing records, see “Importing data into FileMaker Pro” on page 122.
15-12 FileMaker Pro User’s Guide Creating a SQL join Using the WHERE SQL clause The SQL query has joined information from the Sales_Data table and the Salespeople table 12. Click the ORDER BY tab to sort the records before importing them To import data using a SQL join: 13. Select the name of the column to sort by, Sales_Data.Amount. 1. In the Specify ODBC SQL Query dialog box, click Clear Query to remove the SQL statement from the SQL Query box. 14.
Using ODBC with FileMaker Pro 15-13 • The Perform without dialog option hides all dialog boxes encountered during an ODBC import. If you haven’t specified a data source to import from, you must manually select ODBC in the Open File dialog box while performing the import script. • The Restore import order ScriptMaker option stores the field order in the Import Field Mapping dialog box, similar to other scripted imports.
Appendix A Customizing FileMaker Pro This appendix shows you how to customize FileMaker Pro by setting application and document preferences for options like: 3. Click OK. • network protocol and user name • color palette • memory and saving • plugin activation • graphics storage • actions to perform automatically when opening and closing a file • spelling Setting general application preferences Mac OS Setting application preferences Application preferences apply to any file you open.
A-2 FileMaker Pro User’s Guide Do this To Select To Windows: Type a name for User name Set the name that identifies the user. This value is used, for example, when you choose Insert Mac OS: Select System in the menu > Current User Name, or as the host name when you host files on a network. User Name area Always lock layout tools Keep a layout tool selected until you select a different one or press Enter.
Customizing FileMaker Pro Do this To Select during idle time Save changes when the file is idle or when the file cache is full. Select every or when necessary, then choose an interval from the list Save changes at a specified time interval or when the file cache is full. Saving less often on batterypowered portable computers conserves power. Saving more often reduces the chance of data loss in a system crash.
A-4 FileMaker Pro User’s Guide FileMaker Pro matches the text in the left column of the Dialing Preferences dialog box with the phone number in your database. When it finds the longest matching entry in the left column, it dials the corresponding entry in the right column. In this example, if the number in your database is 408 5553930, FileMaker Pro dials 3930.
Customizing FileMaker Pro A-5 Setting document preferences Document preferences affect the current database file. You can set different document preferences for different files. Note A shared file has the same document preferences for every user. You can change the document preferences if you have the master password or if there isn’t password protection in the file. See chapter 9, “Protecting databases with passwords and groups.” To set document preferences: 1. Open a FileMaker Pro file. 2.
A-6 FileMaker Pro User’s Guide Setting document spelling preferences FileMaker Pro can check your spelling as you type. You can also have the Spelling dialog box always appear where you place it onscreen. Select how you want to be alerted as you type Choose where you want the Spelling dialog box to appear To use the spelling checker, see chapter 2, “Adding and viewing data.
Appendix B Backing up and recovering files Power failures, hardware problems, and other factors can damage a FileMaker Pro file. While the recover feature of FileMaker Pro may be able to salvage your damaged file, it is strongly recommended that you back up your important FileMaker Pro files on a regular basis. Consistent and properly executed backups are the best protection against damaged or corrupted databases.
B-2 FileMaker Pro User’s Guide 4. Enter the following script: Set Field ["Count Field", "Count Field + 1"] If ["Count Field > 4"] Save a copy as ["Backup Copy"] Set Field ["Count Field", "0"] End if 5. After adding all the steps above, click OK. 6. Click Done. 7. Choose Edit menu > Preferences > Document. 8. In the General tab (Windows) or the General popup menu (Mac OS), under When closing , select the Perform script checkbox.
Backing up and recovering files quit will occur when the file is between harddrive updates. In this situation, the next time the database is opened, FileMaker Pro runs a consistency check on the file and the file typically opens without problems. However, if the unexpected quit occurs during a hard drive update, the file is likely to require recovery.
B-4 FileMaker Pro User’s Guide 3. Choose File menu > Recover. 4. In the Open Damaged File dialog box, select the file you wish to recover. 5. Click Open. 6. Name the recovered file, and make sure that it is being saved to the desired location. FileMaker Pro inserts Recovered as the default name. 7. Click Save. FileMaker Pro will attempt to recover the file. For large files, this may take some time, as each record, field, layout, and script must be tested and copied to the new file.
Appendix C FileMaker Pro Quick Reference (Windows) Keyboard and mouse shortcuts Working with layout objects Show/Hide T-squares Ctrl+T Align objects using the current settings Ctrl+K Square the object being resized Ctrl+resize Align to grid off while resizing/moving an object Alt+resize / Alt+drag Toggle the current tool with the selection tool Enter (numeric keypad) Bring an object forward Ctrl+Shift+[ Toggle the object grids Ctrl+Y Bring an object to the front Ctrl+Alt+[ Ungroup objects
C-2 FileMaker Pro User’s Guide Move insertion point to end of the word Ctrl+B Move insertion point to the beginning of the word Ctrl+A Move insertion point to start of line Home Move insertion point to start of text Ctrl+Home Select a word Double-click Select a line Triple-click Select a paragraph Four clicks Select entire contents of a text area Five clicks or Ctrl+A Editing Bold selected text or object Ctrl+Shift+B Remove all style from selected word or object (return to Plain) Ctrl+S
FileMaker Pro Quick Reference (Windows) Miscellaneous actions C-3 Move object in list in dialog box Ctrl+C or Ctrl+D Esc Omit Record (Browse) Ctrl+M Cancel a paused script Alt+N Omit Multiple (Browse) Ctrl+Shift+M Check/Uncheck the Omit checkbox in Find Alt+O Play or record sound in a sound field Space bar Define Fields dialog box Ctrl+Shift+D Select all Ctrl+A Find/Replace dialog box Ctrl+Shift+F Sort Ctrl+S Execute script (first 10 scripts) Ctrl+1 — Ctrl+0 (by number) Use the lay
Appendix D FileMaker Pro Quick Reference (Mac OS) Keyboard and mouse shortcuts Working with layout objects Set Alignment dialog box Shift-2-K Show/Hide T-Squares 2-T Sliding/Printing dialog box Option-2-T Align objects using the current settings 2-K Square the object being resized Option-resize Align to grid off while resizing/moving an object 2-resize/ 2-drag Toggle the current tool with the selection tool Enter Shift-2-[ Toggle the object grids 2-Y Bring an object to the front Option-2-
D-2 FileMaker Pro User’s Guide Move insertion point to the end of the word Option-B Move insertion point to the beginning of the word Option-A Move insertion point to start of line 2-A Move insertion point to start of text 2-C Select a word Double-click Select a line Triple-click Select a paragraph Four clicks Select entire contents of a text area Five clicks or 2-A Shift-2-P Shadow selected object or text Shift-2-S Spell check the selected word Shift-2-Y Subscript selected object or
FileMaker Pro Quick Reference (Mac OS) Miscellaneous actions Help 2-? Cancel a dialog box Esc Modify the last find 2-R Cancel an operation 2-.
Index Symbols A ! 36 – 53, 113 " 53 " " 32, 33, 112, 114, 1112 ## 711 & 53, 114 ( 53 ) 53 * 32, 36, 53, 113 + 53, 113 , 53 ...
I-2 FileMaker Pro User’s Guide viewing databases in 143, 146, 1414 views for 1414 Browsing records access privileges 91 described 21 groups of 21 in a list 22 individually 22 on Web 1414 sorted 38 Builtin home page 143, 146, 148 hiding databases on 146 Buttons borders 717 changing appearance 714 copying or deleting 1013 defining 1012 described 1012 nonprinting 725, 1013 performing scripts 102, 1012 showing 1013 C Cache, setting size A3 Calculation fields changing 512 defining
Index file sharing 16, 131 importing 121 Crystal Reports 152 Currency exporting formats 127 formatting 622 Current date formatting 624 in calculations 117, 1111 inserting on layout 711 pasting into fields 210 field 26 record 23 time formatting 624 in calculations 1112 inserting on layout 711 pasting into fields 210 user name inserting on layout 711 pasting into fields 210 setting A2 Current file.
I-4 FileMaker Pro User’s Guide main 214 user adding words 215 described 214 DIF format 121 Display formats 622 Document preferences A5 Double arrow icon 132 Drag and drop described 29 disabling 29 enabling for text A2 fields onto layout 616 objects 613 Drivers, ODBC 151 Drop shadow effect, objects 715 DRW format 212 Duplicate database files 810 Duplicate records finding 36 finding with scripts 1013 Duplicating. See Copying Dynamic Data Exchange.
Index described 12 displaying 13, 61 duplicating definitions 511 Edit items 29 editing 511 empty, finding 36 entry options 58 formatting 621, 71 scroll bars 72 identifying records 1014 indexing 511 lookups defining 86 updating 813 maximum text entry 27 merge 617 moving between files 613 naming 55 opening URL from 28 options 55 Other items 29 pasting into 210 patterns 72 placing on a layout 615 planning 51 positioning 614, 719 removing from a layout 617 reordering definitions 5
I-6 FileMaker Pro User’s Guide Formats default 622 display 622 international 17 Formatting calculations 622 custom line spacing 713 dates 623 export data 127 fields defaults 622 text 712 graphics 624 import data 121 merge fields 618 paragraphs 712 repeating fields 77 scroll bars 72 tables 610 text 622, 712, 713 times 624 Forms See also Layouts Standard form layout 63 viewing records as 22 Formulas calculation fields 55 changing 511, 512 constants 112 described 111 expressions 11
Index I Identification fields 1014 Importing See also Exchanging files, Exporting, Inserting appending new records 122, 123 canceling 125 crossplatform considerations 121 data order 122 described 121 destination file 122 dictionaries 214 Excel spreadsheets 124 exception fields 122 field order 124 field types 126 file formats supported 121 found set 125 into existing files 123 layouts 68 ODBC data 155–1513 from more than one table 158, 1511 options 122 record order 122 related record
I-8 FileMaker Pro User’s Guide deleting fields from 617 described 13, 61 duplicating 68 Envelope 65 field boundaries 717 fields displaying 13, 61 dragging onto layout 616 placing 615 removing 617 selecting 612 form layout 63 form view 22 graphic objects 714, 716 importing 68 Labels 64 margins 722 modifying 68 naming 68 objects adding 612, 714, 716 deleting 613 enhancing 715 locking 615 nonprinting 725 on Web 1412 placing related records 616 print area 722 printing overview
Index Mode popup menu 13, 61 Modems, configuring A3 Modes 13 Modifying. See Changing Movies deleting 213 inserting into fields 212 script step 107 moving 212 on the Web 144 pasting 213 playing 212 Moving fields between files 613 movies 212 objects between applications 613 between layouts 613 on layouts 614, 719 part labels 628 record to record 24 to calculation fields 27 to summary fields 27 Multikey fields 86 Multimedia 212 Multiple platforms.
I-10 FileMaker Pro User’s Guide inserting on layout 711 Page orientation for printing 42, 44, 45 Pages, Web setting up 1410 viewing databases in 143, 1410, 1414 Palettes color 715, A2 pen 715 Size 614, 719 tools 714 Paragraphs attributes 713 formatting 712 Parameters separating 115 Parameters, function described 115 Part labels, displaying 628 Parts.
Index specifying user names A2 storing graphics A5 using smart quotes A5 Web Companion 147 window size A5 Prefixes 211 Preview mode 13, 43 Previewing See also Printing columns 69 layouts 43 records 43 subsummary reports 628 Primary keys. See Match fields Print area objects outside 722 viewing 43, 722 Print preview.
I-12 FileMaker Pro User’s Guide described 82 displaying in portals 616 duplicating 25 exporting 127 finding and omitting 34 importing 122 sorting 811 summarizing data 812 Relational databases See also Portals; Related fields; Related files; Related records; Relationships copying related records 25 defining 89 defining portals 619 deleting related records 25 described 82 duplicate filenames for 810 finding and omitting related records 34 manytomany relationships between data 815 master fi
Index menu items 105, 1010 remarks 109 automatically performing A5 automating relookups 108 backup script B1 buttons 1012 changing 1010 commands 106 copying 17, 1010 DDE 109 defining 104 deleting 1010 deleting menu items 1010 described 102 designing 103 dialing phone numbers 109, A3 displaying error messages 106 duplicating 1010 examples 1013 external 102 for ODBC import 1513 importing 1011 keyboard shortcuts 1011 looping 106 modifying 1010 naming 104 passwords 91 pausing 102
I-14 FileMaker Pro User’s Guide master records with related fields 39 on break fields 628 records in table 22 records on Web 1413 related fields 39 related records 811 relationships in dialog box 811 repeating fields 39 summary fields 310 Sounds copying 28 deleting 213 inserting into fields 212 on the Web 144 playing 213 recording 213 Source file, import 122 Space, removing blank 722 Spelling See also Dictionaries checking 214 options 214 setting preferences A6 Splitting repeating fiel
Index copying 214, 613 cutting 214, 613 deleting 214, 613 editing 214 fields 54 finding 33 formatting 622, 712 line spacing 713 operators 114 paragraphs 712 pasting 214, 613 removing 214 replacing 214 rotating 718 selecting 213, 612 styles 712 tool 710 typing values in fields 27 using drag and drop A2 Text fields.
I-16 FileMaker Pro User’s Guide home page 143, 146, 148 Instant Web Publishing browser pages 143, 146, 1414 remote administration 148 requirements 143, 144 setting up 147 setting up layouts 1412 styles 1411 testing databases 1413 tracking user activity 1113, 148 Web Security Database 145, 149 Web styles 1411 Wide layouts printing 42 Wildcards in searches 32 Windows setting size A5 WKS format 128 WK1 format 121 Workgroups, sharing files 142, 147 World Wide Web.
