WHAT I’D LIKE TO SEE: Temporary Relationships During Script Execution

From Dwayne Wright - Certified FileMaker 9 Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright

This is one of many quick little things I’d like to see in the next version of FileMaker.

Temporary Relationships During Script Execution
There are times in which you need a relationship between two tables to perform a single task, normally during the execution of a script (possibly executed from a script trigger). It is a real drag to have to create a formal relationship in your database relationship graph for a small one time need. It also clutters up any table occurrence pick list and really limits your productivity!

Think of the Set Variable script step and take it one step further and imagine a Set Script Relationship script step. The relationship would only be valid during the execution of the script. With FileMaker Advanced, you could copy the script step as needed from script to script or create a library of temporary relationships.

This could greatly reduce the number of “real” relationships you would need in the relationship graph and that makes the selection of any table occurrence much easier to use in the script.


Check out Tim Dietrich's post FILEMAKER PRO 10: What's Missing? at his FileMaker Addict Blog.

More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2009 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

ADVERTISEMENT ==================
MacUSA provides website and FileMaker Pro hosting services. Utilizing the highest performance web and FileMaker servers. We make FileMaker database hosting as simple as possible. Mac USA Technical Support has been voted the best by our customers. FileMaker Server hosting for your FileMaker web hosting needs supporting FileMaker 10 down through version 5. Hosting FileMaker Pro databases for Instant Web Publishing and Custom Web Publishing including PHP, XML, ODBC, and MySQL access. Use Promo Code dw0904TB for FREE setup (a $25 value) when signing up for your FileMaker Hosting services. Offer expires 6/30/2009. http://macusa.net