I've defined several global fields in FMP5 but they aren't acting properly. I want the user to enter their own values into the fields and have it saved. Unfortunately, some of the globals save the data entered and some don't, meaning that when I come back into the application the values in the global dields have reverted back to whatever they were before. Any idea why this may be happening?

Thanks

The Mad Jammer

Hi Jam,

This topic has been discussed many times in the past.

What you are experiencing is the expected behavior for files that are being served.

In other words, Globals become local in a served environment, and then revert back to what was entered by the developer, if anything, when the file is closed.

Lee

And so, want you really need is a Preference table that is related to each user record. This table would store values that are particular to each user. If it isn't user specific, then all you need is a preference table. In an open script, use set field to set globals to the values in the prefs table.

Thank you both for your responses. I understand the problem with the server issue. The values are quarterly begin and end dates and they are entered once a year. As I said, I wanted my user to specify their values rather than having to modify a script every year that codes them in.

But, thanks again for the responses.

Jammer

Edited August 22, 200718 yr by Guest

If the quarters can't be calculated based on dividing up the year (you should look into this), then I'd suggest you use a Quarter table where each Quarter and Year is specified with Start and End Dates. Then you can use a Date to Range relationship to get the current Quarter and Year.