My.ADVISOR.com Sign-In
Username
Password
Sign Up 
Go to Article
Advanced Search 

Put Multiple FileMaker Pro Windows to Work

Handling windows in FileMaker Pro can seem confusing at first, but with a few tips, you can be on your way to more efficient data management.

By Geoff Coffey, Six Fried Rice partner, and Advisor Basics of FileMaker Pro technical editor

UNLOCKED -- This article is provided to subscribers of FILEMAKER PRO BASICS ADVISOR or DATABASED ADVISOR or FILEMAKER PRO BASICS ADVISOR. To subscribe or renew, go to Advisor Store.

These days, most FileMaker Pro databases are just one file. When you open this file, you see one window on your screen, full of all the data and interface you (or your colleagues) put there. And often, this one window is enough. After all, you can freely switch layouts, perform finds, and (with FileMaker Pro 9 or newer) resize the window to get a bigger view. But the truth is, FileMaker Pro can do a whole lot more. You can have as many windows as you want, each showing a different layout, found set, sort order, and so forth -- all from the same database file.


Figure 1: Surprise! -- In addition to the obligatory fluff, FileMaker Pro's Window menu has a few unexpected goodies. You can hide any window to temporarily get it out of your way, and show a window that's been hidden. And you can make a new window any time you want.

Nobody would blame you if you never realized this cool trick. After all, the Window menu in most programs is chock full of pretty useless stuff. (Tile Horizontally? Who uses that?) But FileMaker Pro's Window menu is a little more oomphy. You can see for yourself in figure 1.


Hide windows

If you work with more than one database, or your database system has more than one file, it can sometimes seem like your screen is filling up with windows. Of course, your operating system has some tools to help deal with this crowding. On Windows, you can minimize a database window, and it will turn into a little brick in the bottom-left corner of FileMaker Pro's application window, mostly out of the way. On Mac OS X, you can minimize the window to the dock. But both methods are a little messy. If you're a heavy Mac user, your dock is probably already strained to the breaking point. And those little bricks in Windows are ugly and hard to find when you need them.

Instead, try this: With a database window open in FileMaker Pro, choose Window > Hide Window. Poof. The window is gone. But it isn't actually closed. Instead, FileMaker Pro has simply wiped (almost) every trace of it from your screen, so it is completely out of site. If you want it back again, just choose Window > Show Window and select the name of the window in question. It will pop back on the scene, right were it was when you hid it.

This trick might seem a little pointless at first. After all, you could just close the window instead. But a hidden window is more convenient for a few reasons:

  1. It's easier to call back up again. No trips to the Open File or Open Remote dialogs necessary.
  2. When you hide a window, FileMaker Pro remembers where you were. Show it again and you'll be on the same layout and record you were before. And you'll have the same found set, sort order, status area setting, zoom level, and so forth.
  3. If your database is hosted remotely (on a server that isn't in your home or office) it can sometimes be slow to open. But a hidden window reappears in a snap.

If you happen to notice the Window > Show Window menu displays some window names in parenthesis (and you're the curious type), see the sidebar "Two Types of Hidden Windows" to find out what's going on.

Sidebar: Two Types of Hidden Windows

Sometimes when you peek in the Window > Show Window menu, you see something surprising: Some of your window names are in parentheses, like this: (My Database). It turns out these mysterious parentheses are an unending source of confusion for people who care what it's all about. Here's the full scoop.

Although you may not have done it yet, FileMaker Pro database systems can be made up of multiple .fp7 files, all working together to get the job done. A table in one file can relate to a table in another, for instance. You can even write scripts in one file that run other scripts in other files. In fact, this multi-file power is what makes FileMaker Pro capable of dealing with complex, multi-faceted problems and huge amounts of data. But that's a story for another day. The point is, one FileMaker Pro file may "depend" on another one because it uses stuff from that file periodically.

Of course, if you have this sort of setup, you don't have to manually open every file each time you want to do some work. Instead, you can open one file (whichever one you need). If it, in turn, needs something from another file, FileMaker Pro will open that file automatically, on demand. So you don't get vertigo, it doesn't show this second file on the screen. After all, you didn't ask to see the second file -- your database did, and it doesn't have eyes. So although the file is "open" in the strictest computer science sense, it isn't open anywhere on your screen.

When you have a file in this state, it shows in the Window > Show Window menu in parentheses. It's a bit misleading because it isn't a window at all. Instead, it is a database file, with no windows, that FileMaker Pro is using. Because you might want to see it, FileMaker Pro shows it in this menu. Choose it, and FileMaker Pro makes a new window for that database and shows it to you.

So, you may see two things in your Window > Show Window menu: Real windows that you (or some script) has hidden, and database files that don't have windows yet. Windowless files are always shown in parentheses. For the power-users out there, FileMaker Pro never runs a database's On Open script (File > File Options) until a window is shown for that file. So if you select a database in parentheses in the Window > Show Window menu, and it has an On Open script, the script will run automatically.

Put Multiple Windows to Work

No reader comments ... yet.

    What do YOU think about this topic? Share your advice and thoughts using this form.

    Your Name

    REQUIRED : PUBLIC

    Your E-Mail

    REQUIRED : PRIVATE

    Job, Company

    OPTIONAL : PUBLIC

    City, State, Country

    OPTIONAL : PUBLIC

    Your Web Site

    OPTIONAL : PUBLIC

    Your Comment

    Please help everyone by keeping your comments on-topic, using clean language, and not defaming or making personal attacks.


    Your e-mail address is required, but it will not be displayed to the public or given to anyone. See our Privacy Policy. Comments become visible after they pass our spam filter, and spammers and abusers are permanently blocked. Please report spam or abuse.

    Geoff CoffeyGeoff Coffey is the coauthor of the acclaimed FileMaker Pro 9: The Missing Manual and a partner at Six Fried Rice, a FileMaker Pro consulting and training firm based in Phoenix, Arizona. Six Fried Rice brings the power and simplicity of FileMaker Pro to individuals, workgroups, enterprise, and the Web through world-class training, expert advice, and custom development. He loves to hear from other FileMaker fans just about any time, and can be reached at geoff@sixfriedrice.com. http://sixfriedrice.com

    Printer-friendly
    page layout

    Keyword Tags: FileMaker, FileMaker FileMaker Pro, FileMaker Users

    ADVISORAMA
    You can always tell luck from ability by its duration.

    ARTICLE INFO

    FileMaker Pro Basics Advisor

    Web Edition: 2008 Week 01, Doc #19341

    Print Edition: Issue #12, Page 8

    SUBSCRIBER ONLY ARTICLE LOCKED

    Subscribe to FileMaker Advisor Magazine

    Read the advanced guide to creating custom business database solutions with FileMaker software. Subscribe now to gain access to all the archives and downloads.

    FileMaker.Advisor.com

    Subscribe to Advisor Basics of FileMaker Pro

    Learn the fundamentals of using FileMaker Pro software. Every issue gives you step-by-step instructions on creating the databases you need. Subscribe now!

    FileMaker.AdvisorBasics.com

    Free E-Newsletters

    Keep up! Hot News, How-To, Tips & Tricks, Expert Advice, and more. Click to request your's free.

    AdvisorUpdate.info

    Need Know-How Now?

    What direction are you going with your business? Advisor Guides are packed with the answers you need to work smarter. Can you afford to fall behind?

    AdvisorStore.com

    Showcase Your Smarts

    Submit your tips, techniques and advice and let Advisor promote your business and build your career. Show the world what you know!

    AdvisorTips.com

    Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
    Portions copyright ©1983-2008 Advisor Media, Inc. All Rights Reserved.
    Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
    ADVISOR®, the ADVISOR logo, and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, Inc. in the United States and/or other countries.
    Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
    coffg007 posted 01/02/2008 modified 05/14/2008 03:44:17 AM ztfmfu/ztfmfu
    domino-144.advisor.com my.advisor.com 05/16/2008 12:22:27 PM