Grabbing values from 'distantly' related tables

[AndrewCr]

Lets say I have three tables where:

 

Table A is the master of B and in turn B is the master of C.

 

What's the best way of grabbing a value from C (based on tricky criteria) to display on report page for A ?

 

Is communicating through a global in B the best way to go for scripting purposes ?

 

Also: Will modifying globals while another user is already in that record work reliably with scripts?

[dj]

First to reply to your second question:

In an shared file globals are not shared amongs users, ie every user has his own set of globals.

BTW what exactaly do you meen with

modifying globals while another user is already in that record

Globals are not asociated with any record but with file itself. Also records are accessed on one-user-per-time basis. Remember that when using portals.

Now, the first question:

For ex. define in B an calc field using relationship with C than display this filed in A using relationship with B (no need for scripting) or as you mentioned use globals for passing data.

However I would prefer the first method to second one.

 

HTh

 

dj