Hello,

I am a newbie as far as a LAMP based CRM software goes and I must admit that I am new to messing around with databases as well. I am using a host PC with Ubuntu 9.10, Apache 2.2.12, MySql 5.1.37, PhP 5, and Sugar Community Edition 5.5

A little background information, I am trying to set up Sugar for use in a PC repair shop and am having trouble with the cases detail view. Ideally I would like to print the detail view and use it as a work order to give to the technician. I have almost everything I need except pulling up the street address for the account and the contact name for the person associated with that account.

From looking around it seems I will have to edit the /sugar/Cases/metadata/detailviewdefs.php and /sugar/Cases/field_arrays.php but it is as this point that I am getting lost.

I have found the corresponding table names in the database but I am unsure how to get them loaded. I did see the data that I want in my cases detail view in the detail views for the accounts and contacts but I am unsure where to put those bits of code and if I would have to make any new relationships between the cases and accounts modules.

Code:
array (
			      'name' => 'shipping_address_street',
			      'label'=> 'LBL_SHIPPING_ADDRESS',
			      'type' => 'address',
			      'displayParams'=>array('key'=>'shipping'),
Code:
array (
	      'name' => 'full_name',
	      'label' => 'LBL_NAME',
	    ),
Here is a mockup of what I intend to end up with and the fields I am having problems with labeled 1 and 2. Any help would be much appreciated.