Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Grabbing values from 'distantly' related tables


AndrewCr
 Share

Recommended Posts

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use