I have a table with 8 global fields. I increment the value of these fields via a script. I created this file on a local computer. When you would exit the file and re-open it, the global fields would retain their value, which is what i want. After moving it to the server and sharing the file, the global fields do not keep their current value after closing and re-opening the file. They revert to their original value. Why does this happen and is there something I can do to stop this behavior? Using FMP 7 and Server 7.

Edited January 13, 200620 yr by Guest

Global fields become local in a served environment.

There are several old thread about this, do a search of the forum for the keywords, server and global.

Lee

Phil:

One way to deal with this issue is to create a separate table in your system to store your globals. This table would only have one record, and would have a regular text/number field for each of your globals. You would set up a startup script to load the data from this table into your globals, and a shutdown script to load the data from the globals into the new table. This way your globals continue to increment, rather than reverting to the original amounts each time you close the file.

-Stanley

That is a great workaround. I'll start working on it now.