Global Field clearing out

[Eliz309]

I created a database with a global field in FM 6 , we have upgraded to FM9 and now use server to serve it. Now the global field erases any changes when we close the file. How do I get it to hold the changes?

[comment]

Globals behave differently with shared files - see, for example:

http://www.fmforums.com/forum/showpost.php?post/275900/

If you want to retain modifications (important: modifications by whom?), you cannot use a global field.

[Vaughan]

A work-around is to create a script and set is to run at file open (in file options). The script uses the Set Field step to put the desired value into the global field.

But as Comment says, this is not a good use for global fields. The best method is to use a "preferences table" - do a search on the forums for more information.

[Eliz309]

Thanks for the suggestions. I will take a look at them and see what will work for us. Thanks again.

[Eliz309]

What if I want the same information to be seen and modifiable by all users on multiple layouts?

Like you would if you were putting a company address on multiple layouts and you would want any user to be able to update it if it changed.

[comment]

See:

http://www.fmforums.com/forum/showpost.php?post/253445/