Hi All,

I have a database with a setup table and a globals table. On the setup layout I have placed a globals description field and a globals price field.

 

I have a laptop hosting the file and I have 3 other laptops that I remote into the database. If I change the a price on the master db the other remote databases do not update.

 

Any ideas would be helpful

 

thanks

 

MG

Global fields become local in a served environment.  Here is a link to  a global search of some of the past threads on this subject. 

 

 

site: fmforums.com globals in a served environment

Thanks Lee. So if I wanted the price field to change on all of the slave machines when the master price field changed I should remove the global part of the price field?

 

Thanks...MG

Yes.

 

I think you misunderstand what a 'global' value is for... And how a networked FileMaker environment works.

 

If you want something reflected across all the 'users', then gobals are not the way.

 

Cheers

Webko

Oh but that means you want a relationship otherwise you can't get those values.  Or you need to trigger them to a global mirror field or something.  Maybe that is why you thought globals should be used?

And the problem with having a relationship is what?

Hello Lee!

 

No problem with having a relationship and I apologise if it sounded that way.  But if it is a single record table, folks use global which is auto-enter replace to its same standard field and trigger it to use elsewhere or they must create a relationship.  Sometimes that means creating a relationship from this table to other tables a LOT.  That's why many times I read globals are used to hold the real fields' values then triggered.  This makes the global available throughout the file without a relationship.

 

So I was just trying to point out that, if he changes from global to regular field, the values might not be accessible to those other tables UNLESS he creates a relationship or takes so other action such as trigger the globals to update.

 

Thank you for asking me to clarify.  I have so much swirling in my brain from studying that I get brain freeze.  LOL.  A few friends told me I'll get brain tumour from all computer work.  I told them I'd rather have brain tumour than AIDS which THEY will get because they party constantly.

 

Hey, Matrixxdwg, I like your avatar a lot.  I guess it is time I get one, eh?