ADVISOR BASICS OF FILEMAKER PRO -- The Advisor Guide to FileMaker Pro database basics, providing help and how-to, step-by-step solutions to do what you want, fast and easy, with FileMaker Pro database software for Windows and MacOS. --

New Know-How for Subscribers
Top 15 for 2009 Week 02

ACCOUNTING

Accounting Basics for the FileMaker Developer

Facing an accounting integration project? Is the jargon too much? Learn how you can go from trepidation to celebration.

By Laura Bowyer, David Lommel, and Jason Young

DEVELOPMENT BEST PRACTICES

Document Your FileMaker Pro Solution ... Without Documenting It

Being able to come back six months later and easily make sense of a application is what naming conventions are all about.

By Bill Heizer and John Mark Osborne, technical editor

Are You a FileMaker Pro Power User?

What does it take to be a FileMaker Pro power user? If you've ever thought you might be one -- or perhaps doubt your abilities -- read on!

Moderated by Liz Novak, Advisor Basics of FileMaker Pro managing editor

DATABASE DEVELOPMENT

FileMaker Indexing Explained

Indexing your data improves solution performance and can help you in many ways, but it can be a little tricky to figure out how it all works. Get to know the ins and outs of FileMaker Pro indexing here.

By Doug Gardner, Exoteric Inc. owner

ADVISOR ANSWERS

Create Mail Merge E-Mails in FileMaker Pro

Learn how to convert customized form letters from a word processing program to electronic format.

By Lee Lukehart, Soliant Consulting director of training

ADVISOR TIPS

Find Files Easier in a FileMaker Pro Drop-Down List

Learn about a better way to find what you're looking for in a long drop-down list.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

ADVISOR ANSWERS

Flip FileMaker Pro Found Sets Fast

By Lee Lukehart, Soliant Consulting director of training

Put FileMaker Pro Templates to Work

Learn how to use the Issue Tracking Template to manage technical requests.

By Molly Connolly, Thorsen Consulting owner

ADVISOR ANSWERS

Minimize FileMaker Pro Calculation Confusion

Learn how to use multiple functions in a single calculation while still keeping all your formulas straight.

By Lee Lukehart, Soliant Consulting director of training

Manage FileMaker Pro Scripts with Copy and Paste

Save time and play it safe: copy and paste scripts that already work.

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

ADVISOR TIPS

Extend the FileMaker Pro Found Set, Script Style

Learn how to script a find that adds matching records to your current found set of records.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

BENTO

Supercharge Your Address Book with FileMaker Bento

FileMaker, Inc., has given us a brand new way to manage data. Find out what you can (and can't) do with Bento.

By Maria Langer

APPLICATION INTEGRATION

Connect FileMaker Pro to Corporate Databases with ESS

With FileMaker 9's External SQL Sources feature, you can make the connection to high-end corporate databases with no complicated programming.

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

ADVISOR ANSWERS

Uncover Reasons for Strange Layouts After FileMaker Pro Upgrades

Discover the reasons for some odd layouts after an upgrade.

By Lee Lukehart, Soliant Consulting director of training

ADVISOR TIPS

Master FileMaker Pro Keyboard Shortcuts

One of the best ways to be an efficient developer is to master FileMaker Pro's keyboard shortcuts. If you make an effort to learn them, you'll accumulate some truly useful time savers. Here are some favorites.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

Advisor Basics of FileMaker Pro articles

Advisor Guide to Using FileMaker Pro

Search Advisor Basics of FileMaker Pro articles

ADVISOR NETWORK

DIRECTORIES

ACCOUNTING

Facing an accounting integration project? Is the jargon too much? Learn how you can go from trepidation to celebration.

By Laura Bowyer, David Lommel, and Jason Young

DEVELOPMENT BEST PRACTICES

Being able to come back six months later and easily make sense of a application is what naming conventions are all about.

By Bill Heizer and John Mark Osborne, technical editor

What does it take to be a FileMaker Pro power user? If you've ever thought you might be one -- or perhaps doubt your abilities -- read on!

Moderated by Liz Novak, Advisor Basics of FileMaker Pro managing editor

DATABASE DEVELOPMENT

Indexing your data improves solution performance and can help you in many ways, but it can be a little tricky to figure out how it all works. Get to know the ins and outs of FileMaker Pro indexing here.

By Doug Gardner, Exoteric Inc. owner

ADVISOR ANSWERS

Learn how to convert customized form letters from a word processing program to electronic format.

By Lee Lukehart, Soliant Consulting director of training

ADVISOR TIPS

Learn about a better way to find what you're looking for in a long drop-down list.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

ADVISOR ANSWERS

By Lee Lukehart, Soliant Consulting director of training

Learn how to use the Issue Tracking Template to manage technical requests.

By Molly Connolly, Thorsen Consulting owner

ADVISOR ANSWERS

Learn how to use multiple functions in a single calculation while still keeping all your formulas straight.

By Lee Lukehart, Soliant Consulting director of training

Save time and play it safe: copy and paste scripts that already work.

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

ADVISOR TIPS

Learn how to script a find that adds matching records to your current found set of records.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

BENTO

FileMaker, Inc., has given us a brand new way to manage data. Find out what you can (and can't) do with Bento.

By Maria Langer

APPLICATION INTEGRATION

With FileMaker 9's External SQL Sources feature, you can make the connection to high-end corporate databases with no complicated programming.

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

ADVISOR ANSWERS

Discover the reasons for some odd layouts after an upgrade.

By Lee Lukehart, Soliant Consulting director of training

ADVISOR TIPS

One of the best ways to be an efficient developer is to master FileMaker Pro's keyboard shortcuts. If you make an effort to learn them, you'll accumulate some truly useful time savers. Here are some favorites.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

BENTO

FileMaker, Inc., has given us a brand new way to manage data. Find out what you can (and can't) do with Bento.

By Maria Langer

DATABASE DEVELOPMENT

In-house and consulting developers tend to be experts on different, complementary pieces of the software development picture. Learn how to bring these talents together to build more and better FileMaker Pro solutions.

By Michael Reddy, Ph.D.

DATABASE DEVELOPMENT

In-house and consulting developers tend to be experts on different, complementary pieces of the software development picture. Learn how to bring these talents together to build more and better FileMaker Pro solutions.

By Michael Reddy, Ph.D.

ADVISOR ANSWERS

Want to spiff up a solution? Scripting is the answer. Find out how scripting can help your solutions look great.

By Lee Lukehart, Soliant Consulting director of training

Learn some shortcuts that can have you finding just the right data with few keystrokes.

By Jason Mundok, IT Solutions Consulting project manager and FileMaker developer

ADVISOR TIPS

The super search is a method for quickly searching several fields without having to enter Find mode. Learn how to use it.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

ADVISOR TIPS

Learn an innovative technique that wouldn't have been nearly as elegant before FileMaker Pro 9.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

ADVISOR ANSWERS

Finesse your buttons by making the highlight the same shape as the button.

By Lee Lukehart, Soliant Consulting director of training

Help users see the correct information when they first open your FileMaker Pro solution.

By Paul T. Mitchell, Soliant Consulting technical manager

ADVISOR ANSWERS

Find out when you'd use Set Variable, and what the difference is in variable names starting with $ versus $$.

By Lee Lukehart, Soliant Consulting director of training

Get it all -- every current and past ADVISOR tech/business publication, now all-in-one subscription, with new articles and a huge reference library packed with expert advice, how-to and downloads. Subscribe now to get it all.

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!

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