Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Murali KrishnaMurali Krishna 

regarding MD relationship

hi,

 

i got a requirement like,

i have object which is master to two objects

i got a field called f1 in master object

i got a field called f2 in 1st child and 

i got a field called f3 in 2nd child.

i got value 20 and 30 in f2 and f3,i need to added and dispplayed in f1

 kindly help me with this

 

Best Answer chosen by Admin (Salesforce Developers) 
bob_buzzardbob_buzzard

I reckon you'll need the following:

 

On the master: 

 

(1) A roll up summary field that totals the f2 fields from all children

(2) A roll up summary field that totals the f3 fields from all children

(3) A formula field that adds together the values of roll up summary fields (1) and (2)

 

Then on the child records:

(1) A formula field that pulls the value from (3) above.

 

 

 

All Answers

Rajesh SriramuluRajesh Sriramulu

HI,

 

Try to create Roll Up Summary on Master object.

 

Regards,

Rajesh.
bob_buzzardbob_buzzard

Are you looking to sum these values for all child records or just for particular instances?  I.e. you say that you have 20 and 30 in f2 and f3, but that will be for one instance of child 1 and child 2.  
Murali KrishnaMurali Krishna
not for just one instance when ever the child records are entered with the values,master record should be udated with the sum and also the tell how to the reverse direcction when the master field is entered with the value that value needs to be shared with child records
Murali KrishnaMurali Krishna

not for just one instance when ever the child records are entered with the values,master record should be udated with the sum and also the tell how to the reverse direcction when the master field is entered with the value that value needs to be shared with child records
bob_buzzardbob_buzzard

I reckon you'll need the following:

 

On the master: 

 

(1) A roll up summary field that totals the f2 fields from all children

(2) A roll up summary field that totals the f3 fields from all children

(3) A formula field that adds together the values of roll up summary fields (1) and (2)

 

Then on the child records:

(1) A formula field that pulls the value from (3) above.

 

 

 

This was selected as the best answer
Murali KrishnaMurali Krishna

hi

 

tried as u ssaid  and excuted well.thank you very much,similarly how can i get field value from master to childs field
Murali KrishnaMurali Krishna

hi bob,

 

 

got every thing thank you.