CiviCRM Community Forums (archive)

You will have to manually change it in DB. Another solution would be to export contact with current custom field value. Create new custom field for Contacts and import it again.

HTh
Kurund

Thanks guys, almost there, not quite.  Here are the steps I used.

First, I made a full backup of my database.

Then, find all the Custom Data Groups by running this query on the database.

select id,name,title,extends,extends_entity_column_id as entitiy_id, extends_entity_column_value as entitity_value, table_name from civicrm_custom_group;
After I identified the Group I wanted to change, I simply ran an update query like so:
update civicrm_custom_group set extends='Contact' where id=1;
This had the effect of exposing the custom data field to Organization Contacts, but the data will not save to the database, in other words, I make a selection, click Save, and then it is not stored.

Just as an afterthought, I cleared out templates_c but that didn't help.

I'm sure there is another table somewhere that needs changing, but where?

Hey stoob - if it t'was I, I would go via phpmyadmin, find  mydatabase.civicrm_custom_group

then edit the option I want to change from indiv to contact

and testing shows the data is saving fine - so not sure if that helps your case but for others who might come after us and are more comfortable in that tool