[FX.php List] Global field works on one table but not another?

[Jon Montgomery]

Bob,
    I thought about doing that, and even checked to see if that is what I
had done to the other data base that worked.  It is just two fields and they
don't change very often and when they do, I have lots of time before we use
them.  So I just went to the server and turned off that data base, I am the
only one using it right now, plugged in the data and put it back on line.
All works fine.
    Now that leads to another problem with FMS Admin program.  I cannot
connect remotely like I use to be able to do.  In fact 2 weeks ago I could
login to the FMSA server and now it cannot connect.  Where should I start to
trace the problem down.  Both machines, server and remote, are Mac Intel's
running Mac OS 10.4.10 (client not server).

Thanks!  

Oh, have fun at the DevCon

Jon


On 8/3/07 11:15 PM, "Bob Patin" <bob at patin.com> wrote:

> Jon,
> 
> Another idea would be to use a table with a single record in it, with
> the fields that you are now using as globals. Then you can access the
> fields when you need to, edit them as you need to, and not have to
> worry about dealing with the globals.
> 
> If you'll relate this table to all of your other tables you can then
> access the fields' values whenever you need.
> 
> Hope this helps,
> 
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> 
>    CONTACT US VIA INSTANT MESSAGING:
>       AIM or iChat: longterm1954
>       Yahoo: longterm_solutions
>       MSN: tech at longtermsolutions.com
>       ICQ: 159333060
> 
> 
> On Aug 3, 2007, at 6:41 PM, Jon Montgomery wrote:
> 
>> Dale, Joel and Dan,
>>     Thank you for the quick response.
>> 
>> Dale - after I read your response, I remembered reading that
>> somewhere but
>> at the time it did not apply to anything I was doing.  So it did
>> not remain
>> in memory.  That was the problem.
>> 
>> Joel and Dan - I choose not to go the script way.  And my mind was
>> already
>> numb.  This global has not changed in 5 years so editing it is not
>> a problem
>> once you guys pointed out the problem.
>> 
>> You all have fun at DEVCON.
>> 
>> Jon Montgomery
>> Illinois Grade School Music Association
>> 
>> 
>> On 8/3/07 4:36 PM, "Dale Bengston"
>> <dbengston at preservationstudio.com> wrote:
>> 
>>> When you're working on a hosted file, the globals are "temporary" to
>>> the current user. If they were blank when the table was hosted, they
>>> will revert the next time you open the file.
>>> 
>>> To get globals to stick, you have to open the file locally with FMP
>>> client, set the globals and then re-host the file.
>>> 
>>> Dale
>>> 
>>> On Aug 3, 2007, at 4:30 PM, Jon Montgomery wrote:
>>> 
>>>> I have two data bases that were accessed via FX.PHP. Last year all
>>>> worked
>>>> fine.  Clients entered events and then printed a billing sheet that
>>>> they
>>>> mailed in.  Those billing sheets had some global fields for the
>>>> fees and
>>>> every thing worked!
>>>> 
>>>> Now to take advantage of another table that ended up being the same
>>>> in both
>>>> data bases.  I move the information in the second data base to the
>>>> first
>>>> data base (copy and paste the fields).  Recreated the needed
>>>> layouts.  But
>>>> for some reason, the Global fields in this new table do not work.
>>>> I enter
>>>> the fees in FMP and then when I quit the data base and then go back
>>>> on line,
>>>> those global fields are blank.  I am not sure what I did
>>>> different?  The
>>>> global field in the other table work fine.
>>>> 
>>>> Is there some checkbox I am missing in the Define Data Base?
>>>> Indexing?  Any
>>>> help would be appreciated.
>>>> 
>>>> I even tried going back to the old second data base (the one I
>>>> copied the
>>>> fields from) and it works.  All global info is there.  But not in
>>>> the new
>>>> table in the first data base.
>>>> 
>>>> Any ideas?
>>>> 
>>>> Jon Montgomery
>>>> 
>>>> -- 
>>>> Jon Montgomery
>>>> Illinois Grade School Music Association
>>>> Home email: vicepresident at comcast.net
>>>> IGSMA email: vicepresident at igsmasouth.org
>>>> School email: jwmontgomery at dqud300.perry.k12.il.us
>>>> 
>>>> 
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>> 
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>> 
>> 
>> 
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>