FileMaker Pro 9, the best-selling easy-to-use database software from FileMaker, Inc., was named Best Database Management Solution at last night's 2008 Software & Industry Information Association (SIIA) CODiE Awards held last night in San Francisco.
FileMaker Pro 9, for Mac, Windows, and the Web, is used by a huge variety of customers to manage people, projects, assets and more.
750 of the software industry's most prestigious and authoritative software companies selected FileMaker Pro 9 for excellence in design and development as the Best Database Management Solution for 2008.
"We're delighted that the CODiE Award judges have recognized the significance, value and quality of FileMaker Pro 9," said FileMaker president Dominique Goupil in the press release.
The CODiE awards are awarded annually by the SIIA. Over 1,000 applications were received for this year's CODiE awards.
Labels: Excelisys
FileMaker Tip from Andrew Persons
I run into this situation very frequently, as I'm sure most developers do: I have a record, such as a contact, that is related to a company record via the serial ID. I want to display the company name, so I just place the company name field via the relationship. Pretty standard so far.
But I relate to that contact record in many different places in the relationship graph. I don't want to have to attach a new Company TO to the contact record for every occurrence, so I create a CompanyName unstored calc in the contact table that references the company name through the relationship. That's how I've done it before, that is. Starting in 8.0, FileMaker introduced a feature of pop-up menus (not drop-down lists). Create a new value list in the Company table. Set the first field to the serial ID, and the second field to the company name. Then check the "Show values only from second field" box. Now, any field with that value list attached will display the company name that matches the serial ID in the field, if one exists. Here's the cool thing: this works even if the field isn't enterable. So, you can use this to leverage the contact-company relationship anywhere you want, without cluttering up the RG. And, it has good performance across many records, unlike the unstored calc.Labels: Andrew Persons, Excelisys, Filemaker pro, Tips