FileMaker News

• Join FileMaker at Macworld Expo 2007
• Preparing for Windows Vista?
• Free book offer with purchase of training CDs
• Version 2 of the File Manipulator plug-in
• FileMaker Themes Pack

There's never been a better time to upgrade

If you own FileMaker Pro 6, FileMaker Developer 6, FileMaker Pro 6 Unlimited or FileMaker Server 5.5, you may upgrade to the latest version with a special savings. Visit our online resources to help take advantage of the rich feature set offered in the newest product versions. With this offer, you'll get the most out of FileMaker and save money!

Hurry, this offer expires on December 20, 2006!

Upgrade to FMP 8 Web Seminar»
Migration White Papers »
Upgrade Now»

Get Your Team Working Faster, Sharing More, and Saving BIG—with New FileMaker!

The FileMaker Workgroup Bundle
To make it quick, easy, and incredibly cost-effective for you to join the Volume Licensing Program, we're offering you the FileMaker Workgroup Bundle for a limited time! The FileMaker Workgroup Bundle includes the software you need to get 10 people up and running on FileMaker Pro 8.5. You even get FileMaker Server FREE so your databases will run significantly faster vs. peer-to-peer sharing.

Learn more »

FileMaker Web Seminars: Connect with Knowledge

Take a look at the archive of FileMaker Web Seminars and learn more about FileMaker products. They're FREE and take place on your Web browser. See a range of topics for the beginner or advanced user.

View Archive»

FMP 8.5 Wins Teaching K-8 Editor's Choice!

Databases will never be the same with these technology tools for your classroom
Here's software for creating your own databases with web data input or online history databases for strengthening social studies and history standards. Either way, these will find a place in your curriculum.

Learn more »

Customer Story:

Shipping great works of art for museums and auction houses requires a powerful FileMaker Pro tracking application

From transportation to conservation to installation – top institutions in the fine art world trust Artex Fine Art Services with their most precious and irreplaceable pieces. FileMaker Pro documents every step in every journey of every work shipped, ensuring that Artex staff knows where it's been – where it's going – and when it gets there.

Read more »

Tell your story to the world!
Are you excited about the new features you are using in FileMaker Pro 8.5 or FileMaker Pro 8.5 Advanced and would like to tell the world about it? You can! We're eager to let you tell your story on our Customer Stories pages.

Support Corner

Need a question answered?
FileMaker Customer Service is dedicated to providing our customers with the best non-technical service possible. Non-technical service includes pricing, product availability, pre-sales questions and promotions.

Simply go to the FileMaker Knowledge Base. and ask away!
The FileMaker Support Team

Tips and tricks

Use the Find/Replace Command in FileMaker Pro
Find out how to easily make a change throughout your database.
Compiled by Stuart Gripman

The Replace command is hot stuff, sure, and you can wield it in many powerful ways. But there are some things it just can't do, and that's where the Find/Replace command picks up that slack. If you've ever used a word processor, you're probably familiar with the Find/Replace concept. In one box, you type in what you want to find, and in another, you enter the replacement text. FileMaker Pro's Find/Replace works much the same way, but adds some database-appropriate options. Let's start with a basic example, then explore some of the possibilities.

Suppose you have a database where you're storing menu choices for the participants of an event. In the field "FruitChoices," each record contains some combination of the words apple, banana, and orange, according to the choices each participant has made. Just hours before the event, you learn that an orange shortage has unexpectedly hit and your supplier is sending tangerines instead. For the FruitChoices field to be accurate, you need to locate the ones with "Orange" in them and replace "Orange" with "Tangerine," while leaving all other data unchanged. Although a calculated Replace command could get the job done, Find/Replace is vastly simpler. Just follow these steps:

• Click into the FruitChoices field.


• From the Edit Menu choose Find/Replace > Find/Replace.


• In the "Find what" box, type "orange."


• In the "Replace with" box, type "tangerine."


• From the "Direction" pop-up menu, select "All."


• Set "Search across" to "All records."


• Set "Search within" to "Current field."


• Click on the Replace All button and OK in the confirmation dialog.

You'll see a summary of the actions taken and find that all the oranges in the FruitChoices field have turned to tangerines! Notice the other data in the field remain unchanged. Super cool, super easy, right? Let's complicate it a little now. Suppose your data refers to oranges in many other fields and not just in the "FruitChoices" field. You can simply repeat the process above, selecting "All fields" in step 7 instead of "Current field." FileMaker Pro will find every instance of "orange" in your data and replace it — something the Replace command can't do.