CiviCRM Community Forums (archive)

Hi All,

I have recently installed civiCRM on Drupal. I am a beginner with drupal,PHP and civiCRM.

I need some help regarding creating custom data groups in civiCRM.

1) When I create a custom data group for custom fields, I notice that for the fields that have multiple select options, the data group stores all the multiple selected values in one cell of the new database table. This means that the new data group that I just created is not even in the first normal form as there are more than one values in one cell. Is there a way to make civiCRM to store multiple select values in separate rows?

2) When we create a new data group it is mandatory to select an appropriate "Used for:" option. How do we create certain tables that are not directly related to any of the "Used for:" options i.e.(Activities, Contacts .... Relationships)? These tables have foreign key relations to define certain fields of some other tables that will be related to contacts. For example: I have a "Consumer" table that will be related to Contacts. I have another table "Pension_Benefits" this table defines all the possible pension benefits that the consumer can have (Foreign key relation with "Consumers"). How do I create the "Pension_Benefits" table (do not know what to select in the "Used For:" option of custom data groups)?

Thanks a lot for your time and help.... 

Regards,