global calculation field and relationship

[barbaras]

Hi everybody,

I'm not sure I'm in the right topic, but anyway it looks for me like a relationship problem.

Here he is. I've a calculation global field (I'm using FM7) in one DB. I would like the value of this field be used by another DB in a script. But, in the second DB the value is always empty

I don't understand ! It does not seem to be the relationship itself, 'cause when I change the global calculation field to a "normal" text field everything works fine, but I need the global calculation field.

so....Help

Thanx a lot

[transpower]

Your profile says "FMP: 6" yet you say you're using FM7. Anyway, what is the relationship between the two files?

[-Queue-]

Globals don't require a relationship to be accessed in FM7. You can directly reference the table containing them, assuming there is a TO in the relationships graph for it.

What is the calculation for the global field? Does it rely on unstored data in the related table? If so, perhaps this field can be set via script instead of calculated.

[barbaras]

Sorry transpower I did'nt setup my profil lately, but it's in fact FM7 that I'm using.

You're right Queue, I also tried directly without a relationship, but nada !

In fact, the calculation rely on unstored data.

I did some tests and it seems that you are right, if I use some stored data everything works fine.

So, thank you for putting me in the right direction,

[transpower]

You could set a normal field equal to the global field by calculation, then reference that. But like, Queue, I'd like to know what your calculating...