Recently, I just used this technique in my upcoming 2.5 release of InBizness SOHO. I have been doing a lot of proposals lately for database work and wanted to streamline the process a bit. A number of my proposals have common milestones and I wanted the ability to copy a similar milestone from one project and place it within the current proposal.

Here you can see the new interface for the milestones module. (you may need to click the image to enlarge. You can see a button in the portal row that copies the primary key fields data into a global variable. This way, that data is available as I go to a different record. I have a self relationship between my milestones table and use a script to place the key id and set the fields in the new milestone equal to the one I copied.

Here you can see the script in the Script Debugger (a feature in FileMaker Advanced)(you can click the image for a larger version)

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

© 2008 - 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.