change field values by changing the dropdown option

[prasannagowri]

hello
I have a drop down in accounts module showing the clinic names if i select a clinic
i have to show the clinic information below.
ex:clinic Address:
Clinic Phone Number:
please guide me your help is appreciated
thanks in advance

[andopes]

You need to create a ajax based javascript to get the clinic information onchange the dropdown.
Another suggestion is to use a default relate field for clinic and this attribute like that into the field defs:

             'displayParams' =>
            array (
              'additionalFields' => array(
                'website' => 'website',
                'phone_office' => 'phone_office',
                'phone_fax' => 'phone_fax',
                'phone_alternate' => 'phone_alternate',
                'employees' => 'employees',
                'annual_revenue' => 'annual_revenue',
                'industry' => 'industry',
                'account_type' => 'account_type',
              ),
            ), 
  

Cheers

[prasannagowri]

hello,
thanks for quick replay,
as u said i created the separate php file by using ajax based javascript

this is my custom code:

$query = "select id,name_of_company,first_name from a234_clinics where id='$id'";
$res = $db -> query($query);
$row = $db -> fetchByAssoc($res);

and i am getting following error:
Fatal error: Call to a member function query() on a non-object in /opt/lampp/htdocs/sugar51/modules/Contacts/.................... on line 298

please help me to resolve this issue,
thanks in advance.

[crmsiva]

Add global $db; to the code.