Need to populate organization and manager from business table based on contact name select
Could you please help me on below requirement.
I have two tables one is businessunit table and other is contacts table.
Businessunit has two columns namely organization and manager with plenty of data in it... and same organization and manager fields I have created in SD.open.interaction form as well...
When I am creating a new interaction from SD.open.interaction form,,,when I select the contact name in SD.open.interaction form, I need populate organization and manager fields from businessunit table to SD.open.interaction form...
Note:each organization and manager fields are related to individual contact name,,,so here we need fetch respective organization and manager field values in SD,.open.interaction to their respective contact names.
Thanks in Advance