Hurry! FileMaker promotions are ending soon! Save money by taking advantage of special FileMaker promotions ending June 30, 2006.
In this Issue:
FileMaker Workgroup Bundle is ending soon!
![[ Workgroup Bundle ]](http://store.filemaker.com/images/promos/10plus1/boxes.png)
Get a free FileMaker Server 8 when you purchase a FileMaker VLA Workgroup Bundle, and you save 50% on Maintenance.
Hurry, this special promotion is ending June 30, 2006!
Buy now »
FileMaker Pro 8 Advanced upgrade promotion is ending soon!
![[ FMP 8 Adv Upg Promo ]](http://www.filemaker.com/images/newsletter/fmp8a_box.jpg)
Licensed users of FileMaker Pro 6, FileMaker Pro 7, or FileMaker Pro 8 may upgrade to FileMaker Pro 8 Advanced for the low price of US$299, a $200 savings off the regular price.
Hurry, this special promotion is ending June 30, 2006!
Upgrade now »
Last chance to save $200 off the FileMaker Developer Conference!
![[ FM Developer Conference 2006 ]](http://www.filemaker.com/images/photos/devcon06_location.jpg)
August 13-17, 2006, Orlando, FL. Join us in Orlando for the 11th annual FileMaker Developer Conference, featuring technical topics for developers of all levels. New this year will be a dedicated Web Publishing track of sessions, and Workshops for Experts. If you create innovative solutions using FileMaker Pro for Windows or Mac OS, and want to expand your solutions to the Web, this conference is for you. You�ll get the in-depth information, intensive instruction, and face-to-face support you need to change the way you develop solutions forever!
Register by June 30, 2006 and save US$200 on your conference registration!
Regsiter now »
Take FileMaker to the next level!
![[ Technical Resource Kit]](http://www.filemaker.com/images/icons/icon_training_materials.jpg){kind=icon}
The free FileMaker Technical Resource Kits are comprised of technical briefs and training modules on the most-popular FileMaker topics.
The technical briefs cover FileMaker development conventions, security and networking. The free training modules offered in each kit come from the FileMaker Professional Training Series III, a comprehensive leader-led training course, which includes 13 modules, designed to help you master FileMaker Pro essentials and to develop and deploy professional FileMaker Pro solutions with ease.
Download now »
FileMaker in the field: Customer success stories
![[ Green County Education ]](http://www.filemaker.com/images/newsletter/email_realty2.jpg){kind=small}
Alaska-based real estate broker finds innovative niches in his business for FileMaker Pro 8 database tools
Alaska real estate broker Greg Erkins, of Flash Realty LLC and Emailrealty.com, builds his whole business around powerful FileMaker Pro 8 database tools. In his own office � and in the offices of agents who've bought his applications for themselves � listings and sales data are thoroughly organized, easily accessed � and readily exported to DVD format for impressive, prospect-catching sales packages.
![[Tell Story]](http://www.filemaker.com/images/newsletter/tell_story2.jpg)
Tell your story to the world!
Are you excited about the new features you are using in FileMaker Pro 8 or FileMaker Pro 8 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
FileMaker Premium Phone Support
FileMaker gives you many options for Premium Phone Support. If you require ongoing technical support, purchase a single case, 5-Pack of support cases, or an annual contract. Learn more.
See you next month!
The FileMaker Support Team
Tips and tricks
Understand Find Symbols
Discover some shortcuts to streamline your searches.
Regular finds are terrific for a solid majority of your database searching needs, but there are many situations where they just aren't enough. When you need to find records that don't match very specific queries like "Smith," find symbols are your ticket.
OK, so, what are find symbols anyway? They're special characters that you enter as part of your find request that cause FileMaker to search the data in special ways. Whenever you enter Find mode, they're sitting over there in the Status Area to the left, just waiting for you to click the Symbols button and try them out.
Wildcard
Let's start with the classic wildcard search. An asterisk in a find request will act as a wildcard character, matching any combination of zero or more characters. For example, if you have a field called Month in your database where you store the full name of the month, performing a find for *ember will return records with the values September, November, and December, but not October or any other month. Think of the asterisk as a placeholder for any given string of text.
Ranges
Another very useful symbol is the ellipsis, which is used to search for ranges. In a find request, type in the low value, the ellipsis (three periods will work, too), and the high value. FileMaker will return all records within the range you specified.
Say your database has a field indicating how much money each person has donated to your charity and you want to know who has donated more than $99 but less than $1,000. In Find mode, enter 100�999 into the donation field and FileMaker Pro will return all records with values from 100 to 999 inclusive. Ranges work with dates, too. If you want to search for all records with dates from May through September, enter Find Mode and type 1/5/2005�9/30/2005 to find the desired records. With dates, be sure to use four digit years to ensure you're searching the correct year or years. This covers just a couple of Find symbols. Next time, you'll learn about the rest!
Get more basic tips for FileMaker Pro 8.»
Get more advanced tips»
Try a free issue of FileMaker Advisor Magazine»
- FileMaker Design Master Class in New York
August 2-4, 2006; Sag Harbor, Long Island, New York. In the conservatory tradition, the Master Class focuses on the work that students bring to the class: their 'master pieces.' Spend three days with an advancedgroup of colleagues to focus on your solution.
- FM.NEXUS introduces Inspector 1.1
Inspector thoroughly analyzes the metadata of solutions built with FileMakersoftware to provide the essential information developers need to build rocksolid solutions, execute intelligent maintenance and keep solutions problemfree. - FileMaker at NECC in July
July 5-7, 2006; San Diego, CA; When you stop by booth #500, you'll get demos of great solutions for educators, a chance to sign up for one of our conferences, and a CD with a free trial version of FileMaker Pro 8, and our Student Assessment and K-12 Starter Kits - Four new FileMaker Authorized Trainers
There are now 13 FileMaker Authorized training companies and 30 individual trainers providing offsite and onsite intermediate-level and advanced training for developers and users who want to master the power of FileMaker Pro 8. The firms are located in Atlanta, Boston, Chicago, Dallas, Minneapolis, Montreal, New York, Ottawa, Philadelphia, Phoenix, San Antonio, San Francisco, Southern California, Toronto and Washington, D.C.
- Extended Workgroup
Bundle Offer!
Buy 10 FileMaker Pro 8 licenses and get 50% off 1-year of Maintenance and a FREE FileMaker Server 8! Act fast, this offer expires June 30, 2006 - The Great Book Giveaway
Enter to win one of 8 books on FileMaker Pro 8 or one of 2 FileMaker magazine subscriptions! - Upgrade to FileMaker Pro 8 Advanced and save $200!
Licensed users of FileMaker Pro 6, FileMaker Pro 7, or FileMaker Pro 8 may upgrade to FileMaker Pro 8 Advanced for the low price of US$299, a $200 savings off the regular price. Offer valid until June 30, 2006.