Sorry for what is probably a noobie question, but I haven't been able to find the answer.

Custom functions would solve a few problems I have, but I don't have a copy of FMP 11 Advanced yet.

If I get a copy of FMP 11 Advanced and make a database with some custom functions, are those function embedded in the database so they can be used by any FMP 11 Pro application? Or do they only work when the database is opened by an FMP 11 Advanced application?

I _HOPE_ to get a version of Advanced, use it to write the needed custom functions and databases, and then let the databases actually run on FMP 11 Pro applications, but before I buy a copy of Advanced I want to verify that this will actually work.

Thank you.

It will work, yes.

FMP Advanced is only needed to write and "embed" the custom functions in the database files. Once in a file they can be used by the normal FMP client and also the FMP runtime engine.

Thank you, Vaughn. Short and sweet.

Note also that only recursive custom functions require the custom function mechanism (otherwise you could just implement them as calculations), and that there are other ways to perform recursive calculations - such as looping scripts or repeating calculation fields.

The ability to create a Custom Function or a Runtime are a couple of good reasons to purchase FileMaker Pro Advanced. And as comment points out, there are other ways to perform a recursive need. However, don't discount the other tools that it also provides. see http://www.filemaker...mp_vs_fmpa.html for the list.

Lee