# Collection Relationships

**URL:** <https://speciforum.org/t/collection-relationships/182>\
**Category:** Configuration & Installation\
**Tags:** Specify-7\
**Created:** [March 17, 2022, 1:57pm UTC](https://speciforum.org/t/collection-relationships/182 "2022-03-17T13:57:39Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Grant](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/grant/32/4255_2.png) [@Grant](https://speciforum.org/u/Grant)\
**Post date:** [March 17, 2022, 1:57pm UTC](https://speciforum.org/t/collection-relationships/182/1 "2022-03-17T13:57:40Z")

</div>

> 📖 This guide explains what collection relationships are and how to set them up in Specify 7.

Collection relationships in Specify allow specimens to be associated with either specimens in another collection or with a taxonomic name in another collection. Some examples of these types of relationships are tissue and voucher, plant and pollinator and host parasite, etc. Specify allows collection objects in two different collections to be related to one another for the purpose of documenting these types of relationships. The collections may be in different disciplines, but are required to use the same catalog number format.

## Relationship Sides

Collection relationships require that one collection be the ‘Source’ and the other the ‘Destination’. In a single relationship, a source may have many destinations, but a destination may only have one source. This is important to remember when choosing which collection will be the source and which will be the destination. For instance, if a bee pollinates several flowers the bee collection would be the source and the flowers would be the destination.

On a database level, the Collection Object Relationship sides are:

**Source:** Left Side  
**Destination:** Right Side

 ![Diagram of the left and right side Collection Objects, left being the source, right being the destination. The left has one object, the right has 3.](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/3/3cdeee70db192e766bf34441da11a5bc53093d61.jpeg)

If you are using a collection relationship to capture a **Host Taxon** relation, there can be only one taxon name for a single event. See:

 ![Diagram of how a CO connects to the destination Taxon](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/5/55a2139b7203bfe36943c7d5bdb37c257848af63.jpeg)

## Relationship Types

Collection relationships can either associate two collection objects (cataloged specimens) or a collection object from a source collection with a taxonomic name in a destination collection. Both relationship types are configured using the same steps, yet each serves a different purpose, with variation in capability and appearance on forms.

### _ **Object Relationship** _

Associates two collection objects. Rendered on Collection Object form.

 ![Object Relationships diagram](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/9/956fa67e5cdbd15f8525c0abf94b15d29bba4147.png)

 ![Query across objects in two different collections](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/5/5b6a59f8e4959e647299d7a1161615c89282dd8e.png)

### _ **Host Taxon ID** _

Associates a collection object with a taxonomic name. Rendered on Collecting Event Attribute form.

 ![Host Taxon diagram](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/d/dd9e87c6415831a808682171789ea1a588bfc295.jpeg)

## Setup

Two steps are required to create collection relationships:

1. The relationship must be configured and named using the Collection Relationship tool in Specify
2. Forms must be edited to include controls which allow the source collection object to be associated with the destination collection object or taxonomic name. Members may contact Specify at **[support@specifysoftware.org](mailto:support@specifysoftware.org)** to request forms that include either of these relationships.

This guide offers setup instructions for object relationships in Specify 7:

> [@Create a Collection Relationship in Specify 7](https://speciforum.org/t/create-a-collection-relationship-in-specify-7/1837):
>
> book This guide explains how to create a CollectionRelType form, how to show the plugins on the forms, and how to query using the Collection Relationship. [!info] Read This First [bookmark Collection Relationships](https://speciforum.org/t/collection-relationships/182) Before you can create a Collection Relationship in Specify, you need to define a CollectionRelType view definition to create a Collection Relationship. If you are unfamiliar with editing forms, please [watch and read our documentation on the subject](https://speciforum.org/t/editing-forms-in-specify-7/1557) before proceeding. Creat…

### Object Relationships:

**Left/Source:**

 ![Left/Source/One-to-Many](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/f/f833914b421721c7f7bc81b48278e5180702c96e.png)

**Right/Destination:**  
 ![Right/Destination/One](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/4/4c926542d961c2470f8cf715abf79f79ec6e3600.png)

### Host Taxon ID Relationships:

**Left/Source:**

 ![HostTaxon Source form example](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/f/f2d340729e2297b367094f2364f8eb8b4c8e455f.png)

**Right/Destination:**  
Taxon tree of right-side collection
