Hi all help needed please

[kobus]

Good Day

i am quite a newby at sugar and would like to know if anyone could assist me with the following:

I need to get my foreign key set as a mandatory field in my tab have customised.

Regards,

[kinshibuya]

what? i didn't understand could you be more specific?

[kobus]

Hi we did setup a new database for our project and now has have several foreign keys in the database we need to set as mandatory fields in sugar. However when we ad the fields in the module builder it just appear as a small thin box with no description of the name whatsoever..... i found this advice on the forum though, think it would suffice?


if($field == "billing_address_city" || $field == "billing_address_state")
{
$this->script .= "addToValidate('".$this->formname."', '".$prefix.$field."', '".$type . "', true,'". $this->stripEndColon(translate($displayName,$this->sugarbean->module_dir)) . "' );\n";
}else{
$this->script .= "addToValidate('".$this->formname."', '".$prefix.$field."', '".$type . "', $required,'". $this->stripEndColon(translate($displayName,$this->sugarbean->module_dir)) . "' );\n";
}

[andopes]

You just need to add the attribute

 'displayParams' => array(
  'required' => true,
), 
  

at field defs in editviewdefs.php

Cheers

[kobus]

Thanks so much!!!!!!