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

DC dan.cynosure at dbmscan.com
Fri Aug 3 15:42:56 MDT 2007


or (sometimes) better... have an opening script (a script that runs when 
the file is opened) set the global to its default value.

problems with that are that if you "open" a file by going to a layout 
with a related field (which "opens" the file) the opener script does not 
run - the FMP file has to be opened by a double-click or a script step.

cheers.

Dale Bengston had written:
> 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
> 


More information about the FX.php_List mailing list