AnsweredAssumed Answered

Unstored Calculations not working when hosted on server

Question asked by cocoa123 on Apr 29, 2010


Unstored Calculations not working when hosted on server

Your post

Hello and thanks for any help you can provide.


I have a FileMaker app that is broken into two database files:  a UI file and a DB file.  The UI file is using the DB file tables as external datasources.   The versions are FileMaker Pro 11 files hosted on FileMaker Pro 10 Advanced Server.


I have an ACCOUNT table occurrence that has about 6 "to many" relationship to a TRANSACTION table occurrence.  The 6 occurrences  form "transaction type" filtered relationships such as travel transactions, training transactions, labor transactions etc.  I also have a "to one" relationship with an ACCOUNT_SUMMARY table.  The ACCOUNT_SUMMARY table has many unstored calculation fields that work with these transaction occurrences.  My layout uses the ACCOUNT table as it's context and shows fields from the account as well as calculated fields from the ACCOUNT_SUMMARY table.


When I run the application locally everything works as expected.  If I go into the Account Layout and look at an account the fields are displaying the underlying ACCOUNT_SUMMARY fields fine.  However, when I upload the two files: UI and DB to FileMaker 10 Server Advanced and run the application Remotely, then the Account Layout is not showing the calculation fields.  The DataViewer debugger shows no value in the ACCOUNT_SUMMARY calculation fields.  Strangely, if I create a new ACCOUNT record and then delete it when running my application initializer script then the calculations work fine for all the ACCOUNT records.  Is there some explanation for this behavior and is there a more elegant solution to force the calculations to fire instead of creating an account record and deleting it in the start up script? It is also weird that I have many other unstored calculations throughout my model and they all work properly; only the ones in that ACCOUNT_SUMMARY table don't initialize.


I appreciate any input you can provide.