Chapter 4. Viewing Records

As eager as you might be to start creating your own database, the truth is you’ll spend most of your time using FileMaker to view and modify existing records. Whether it’s zipping through a big corporate health benefits database or working with your personal cookie recipes, knowing how to get around FileMaker records efficiently will save you lots of work over the long haul.

Opening a File

If you’re working alone and this is your first time using FileMaker, you may not have any records to view. Never fear. To spare you the bother of having to create some records just for viewing, we’ll be using some of the existing records that came with your copy of FileMaker. If you already have a FileMaker database to work with, feel free to use it.

By the way, when you first open a FileMaker file it automatically appears in Browse mode, which enables you to look at a record without worrying about the layout or how it’ll print. For more on each of FileMaker’s four modes, see page 22.

To open a FileMaker database file:

  1. If you haven’t started the FileMaker program, do so now by either choosing ProgramsFileMaker Pro from the Start menu (Windows) (Figure 3.30) or double-clicking the FileMaker Pro icon in the FileMaker Pro 6 folder (Mac) (Figure 4.1).

    To launch the FileMaker Pro application, double-click its icon in the FileMaker Pro 6 folder.

    Figure 4.1. To launch the FileMaker Pro application, double-click its icon in the FileMaker Pro 6 folder.

  2. A dialog box will appear asking whether you want to create a new file using a template, create a new empty file, or open an existing file. Select Open an existing file... and click OK (Figure 4.2). See Using Templates and Scripts on page 209 to learn how templates can save you time in creating your own databases.

    When FileMaker’s opening dialog box appears, choose Open an existing file... and click OK.

    Figure 4.2. When FileMaker’s opening dialog box appears, choose Open an existing file... and click OK.

  3. If you’ve turned off the opening dialog box (see Tip on page 35), you still can open an existing file by choosing File > Open (Figure 4.3). Or use your keyboard: When FileMaker’s opening dialog box appears, choose Open an existing file... and click OK. (Windows) or When FileMaker’s opening dialog box appears, choose Open an existing file... and click OK.When FileMaker’s opening dialog box appears, choose Open an existing file... and click OK. (Mac).

    You also can open an existing file via FileMaker’s File Menu.

    Figure 4.3. You also can open an existing file via FileMaker’s File Menu.

  4. At this point, you can open a FileMaker file you may already have, in which case navigate your way through the dialog boxes to find it. If you don’t have your own file, see the next step to open the example file featured in this chapter.

  5. Navigate your way down to the file Sample02.fp5, nested inside these folders: FileMakerFileMaker Pro 6FileMaker TutorialSample Files (on Macs the path is FileMaker Pro 6FileMaker TutorialSample Files). Open the file by double-clicking it, clicking the Open button, or using the keyboard commands: You also can open an existing file via FileMaker’s File Menu. (Windows) or You also can open an existing file via FileMaker’s File Menu.You also can open an existing file via FileMaker’s File Menu. (Mac). Now that you have the Sample02.fp5 file onscreen (Figure 4.4), we’ll use it to explain how to view records, move from one record to another, and get around within individual records.

    FileMaker’s existing Sample02.fp5 file.

    Figure 4.4. FileMaker’s existing Sample02.fp5 file.

Viewing Multiple or Single Records

FileMaker lets you view records three different ways: as single records using the View as Form choice or as multiple records using the View as List or View as Table choice. Viewing one record at a time helps you see more detail within a particular record. Inspecting multiple records at the same time makes it easier to compare one to another.

To view multiple records:

  • Our example, Sample02.fp5, opens showing just one record (Figure 4.4). To view several records at once, choose View > View as List or View > View as Table (Figure 4.5). Depending on your choice, the file will display as many individual records as your screen can accommodate (Figure 4.6) or display a table of records (Figure 4.7).

    To see more than one record at once, choose View > View as List (left) or View > View as Table (right).

    Figure 4.5. To see more than one record at once, choose View > View as List (left) or View > View as Table (right).

    The View as List choice will display multiple records in the current layout, enabling you to compare one record to another.

    Figure 4.6. The View as List choice will display multiple records in the current layout, enabling you to compare one record to another.

    The View as Table choice uses a simple table layout to display as many records as your screen can accommodate

    Figure 4.7. The View as Table choice uses a simple table layout to display as many records as your screen can accommodate

To view a single record:

  • To view one record at a time, choose View > View as Form (Figure 4.8). The file will shift back to a view with only one record showing.

    Choosing View > View as Form switches the file back to a single-record view.

    Figure 4.8. Choosing View > View as Form switches the file back to a single-record view.

Moving from Record to Record

FileMaker offers you three ways to quickly jump from record to record within any file. And, as with most things in FileMaker, you have several options within each view.

Navigating records in forms

  1. Click on the flipbook’s pages to move forward or backward—one record at a time. Click the lower page to move forward in the sequence (Figure 4.9); click the upper page to move back. A blank upper or lower page indicates there are no more records in that direction (Figure 4.10).

    Click on the flipbook pages to move forward or backward one record at a time.

    Figure 4.9. Click on the flipbook pages to move forward or backward one record at a time.

    A blank page means you’ve reached the end of the record sequence.

    Figure 4.10. A blank page means you’ve reached the end of the record sequence.

  2. To quickly skip ahead or back within the records, click and drag the flipbook’s bookmark bar. Dragging it down will skip you ahead in the sequence (Figure 4.11); dragging it up moves you back.

    Jump ahead in the records by grabbing the bookmark bar and dragging it downward. Dragging it upward will let you move backward through the records.

    Figure 4.11. Jump ahead in the records by grabbing the bookmark bar and dragging it downward. Dragging it upward will let you move backward through the records.

Navigating records in lists and tables

  • You can use the flipbook pages and bookmark bar in List or Table view as well (Figures 4.124.13).

    Dragging the bookmark works in the List and Table views as well. Just grab, drag, and ...

    Figure 4.12. Dragging the bookmark works in the List and Table views as well. Just grab, drag, and ...

    ...jump ahead in your records. Note how the black highlight in the thin bar left of the records now marks the Michelle Cannon entry.

    Figure 4.13. ...jump ahead in your records. Note how the black highlight in the thin bar left of the records now marks the Michelle Cannon entry.

  • The List and Table views also allow you to skip from record to record simply by clicking anywhere within the records visible on your screen (Figure 4.14). This is especially handy when you need to change data in one field within each record. Clicking directly on that field will highlight it, enabling you to begin entering your new data.

    When in List or Table view, you can click directly on any field and it will become highlighted. Once highlighted, you can change a portion or all of the data within the field.

    Figure 4.14. When in List or Table view, you can click directly on any field and it will become highlighted. Once highlighted, you can change a portion or all of the data within the field.

When in List or Table view, you can click directly on any field and it will become highlighted. Once highlighted, you can change a portion or all of the data within the field. Tip

  • When you’re working in List or Table view, a thin black bar just left of the records marks the current record (Figure 4.13).

Navigating directly by record number

  • If you know the number of a particular record, you can go right to it by clicking on the current record number, typing in the desired number, and pressing Navigating directly by record number (Windows) or Navigating directly by record number (Mac) (Figure 4.15). Pressing Navigating directly by record number will automatically highlight the current record number, allowing you to work mouse-free. This method works in Form, List, or Table view.

    You can directly enter a record number by clicking the number just below the flipbook or by pressing the key. Type in a new record number, press (Windows) or (Mac), and you’re there.

    Figure 4.15. You can directly enter a record number by clicking the number just below the flipbook or by pressing the You can directly enter a record number by clicking the number just below the flipbook or by pressing the key. Type in a new record number, press (Windows) or (Mac), and you’re there. key. Type in a new record number, press You can directly enter a record number by clicking the number just below the flipbook or by pressing the key. Type in a new record number, press (Windows) or (Mac), and you’re there. (Windows) or You can directly enter a record number by clicking the number just below the flipbook or by pressing the key. Type in a new record number, press (Windows) or (Mac), and you’re there. (Mac), and you’re there.

Moving within a Record

Getting around within a single FileMaker record couldn’t be easier, but as usual, there are several ways to do it.

Using your cursor to directly select a field works best when you need to change only a couple of items within a particular record. Using the Moving within a Record key generally works best when you’re filling in new blank records or when you want to keep your hands on the keyboard. Both methods work in either Form or List View.

To move by direct selection:

  • Double-click on any field you want to modify (left, Figure 4.16). Once the field becomes highlighted, type in your data (right, Figure 4.16). To reach another spot in the record, click your cursor on the desired field.

    To enter data or modify a field, just double-click on it and type in your data once the field is highlighted.

    Figure 4.16. To enter data or modify a field, just double-click on it and type in your data once the field is highlighted.

To move with the Tab key:

  • After a record opens, press the To move with the Tab key: key to reach the first field. Continue pressing the To move with the Tab key: key until you reach the desired field. To move backward among the fields, press To move with the Tab key:To move with the Tab key:.

To move with the Tab key: Tips

  • You can’t tab to fields that contain calculations or summaries. But the contents of those fields are based on values set in other fields, so it’s not really a problem. Just keep it in mind.

  • FileMaker lets you set the tab order for all the fields in a record. Reordering the tabs is particularly handy if you need to reach only a few scattered fields within each record. For more on setting the tab order, see page 168.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.15.218.133