When Cindy Rudometkin joined the Polly Klaas Foundation as its Response Department Manager, she could see an immediate need for more efficient data management. "The original database was in Microsoft Access, and we found ourselves really limited on what we could do with written reports and generating statistics. We couldn't do any case management on it," she recalls. "So we switched everything over to Microsoft Excel, and kept everything on an Excel spreadsheet, which obviously has no relational capabilities. It kept track of the basic information, but we really wanted to take it a step further and do all of our case management on the database."
The search for a more effective solution soon led to the conclusion that no off–the–shelf product would do. The Foundation's needs required a custom solution — and when the decision was made to build that solution in FileMaker Pro, the search for a developer led to Teddie Pierce of Technology Consulting Alliance, who turned out to be an ideal fit for the job. "Teddie called me back and told me she used to volunteer for the organization when it was first started," Cindy relates. "So she knew all of our history, she knew about casework — it was amazing!"