CiviCRM Community Forums (archive)

hi, at the moment you can only assign relationship 'Referenced by' <> 'Referee' between individual contacts. i mean that you cannot have individual contact 'Referenced by' organisation or vice-verse - organisation 'referenced by' individual. and we really need this as we would like to record the references between individuals and organisations etc.

so i went to 'Administer CiviCRM' > 'Relationship Types' and 'Edit' of 'Referenced by' <> 'Referee' type. but i discovered that 'Contact Type A' and 'Contact Type B' are locked for those relationships. so i cannot change them to value '- select -' which would make the relation selectable by all contacts (why the pull down menu option does not say 'all contacts' is a mystery to me).

so i went to mysql to see table civicrm_relationship_type. and i discovered that some items of this table have 'is_reserved' set to '1' and you cannot change the 'contact type' for them.

so my questions are:
can i just do
    update civicrm_relationship_type set is_reserved=0;
or will it break something?
will it make next upgrade break?
perhaps we can have all values not reserved? why would you reserve them at all?

pleas help.
best regards, Wojtek

1. Contact Type A / B dropdowns have been changed in 4.2 (per your suggestion) to say "All Contact"  instead of "-select-" as the 1st option.

2. Also not sure why some of the non-core relationship types in your install are set to "reserved". Three of the "core" relationship types are set to "reserved" by default (see below), and there is no way in the UI to set additionally defined type as reserved. Apparently somebody did this via direct DB query at some point (possibly because of a dependency between those relationship types and some of your Case type XML file specifications (e.g they're used for a particular role in a particular case). I guess you can use mysql to "unreserve" the specific ones that are a problem for you and then do some tests adding / updating case roles that use them. I don't think changing this flag in the DB will have any effect / cause any problems with regard to upgrade (just don't delete the core reserved types listed below).

- Employee of   Employer of
- Head of Household for   Head of Household is
- Household Member of   Household Member is

HTH