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

[Bob Patin]

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