Filemaker Advanced also offers several other added features such as a script debugger (fairly similar to the one found in access) that makes it well worth the extra dollars.
If you don't have advanced, you have the following options:
- Get someone else to use their copy of FileMaker Advanced to create the custom functions and add them to your files.
- Use field calculations in place of the custom functions. Once you've developed a calculation field that works, you can copy and paste the field's calculation expression from one table to a field in another if you need to. Such calculation fields can be recursive.
- Write a script that performs the calculation with the needed values passed to it in a list of values as the script parameter. Use script triggers to call this script to compute values as needed.
I am using option #3 from your answer and that works OK. Thanks