global field frustration

[pigpants]

I'm using the contents of a global field in a calculation, but I need the contents of the global field to REMAIN THE SAME. This is working on a served file and every time I close the file and re-open it, then contents of my global field disappears.

HELP!!!

thanks.

[CobaltSky]

Hi,

In multi-user mode, global fields are user-specific, and only the value on the host computer is saved when the file closes.

If you want the value to persist after closure, you will have to write it to a normal data field (eg text or number etc) prior to closing the file. If desired, this can be done by an exit script.

Alternatively, if the value will always be the same, you might consider having the global field set by your start-up script.

Last but not least, you could dispense with the use of a global field per se, and instead use a data field in a related 'globals' file, which is connected to your existing database files via a constant relationship (eg one that matches two calc fields with their formulae specified as '1'). Unlike a global field, it will show the same value for all users, and will be saved when the file closes.

[veganboyjosh]

i'm not sure this will help, but if you set the field to a regular text field with the auto-enter option set to data, then when you create a new record, it will have that same data every time. you can then prohibit modification of value, so the data would never change.

the problem with this method, and a possible reason a global field would be better, is that in oirder to change the data in this field, yuo'd need to change the auto-enter options, and if you are wanting your end users to be able to change it based on their needs, you don't want this.

like i said, i'm not sure this will help, but i'm still trying to get my head around the concept of globals. i'm not quite sure that u understand how/why they do what they do, so if this is totally unrelated to what you need, i apologize.

josh