|
|
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.
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.
PAGE 1 of 1 - 2 - 3 - » Next
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:
- It's easier to call back up again. No trips to the Open File or Open Remote dialogs necessary.
- 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.
- 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.
PAGE 1 of 1 - 2 - 3 - » Next
Geoff 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
Keyword Tags: FileMaker, FileMaker FileMaker Pro, FileMaker Users
ADVISORAMA You can always tell luck from ability by its duration.
|
ARTICLE INFO
Web Edition: 2008 Week 01, Doc #19341Print Edition: Issue #12, Page 8
ARTICLE LOCKED
|
|
|

Read the advanced guide to creating custom business database solutions with FileMaker software. Subscribe now to gain access to all the archives and downloads.![]() 
Learn the fundamentals of using FileMaker Pro software. Every issue gives you step-by-step instructions on creating the databases you need. Subscribe now!![]()  ![]()
![]()

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

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?![]() 
Submit your tips, techniques and advice and let Advisor promote your business and build your career. Show the world what you know!![]()  ![]()
|
|