# Create Collection Relationships via the WorkBench

**URL:** <https://speciforum.org/t/create-collection-relationships-via-the-workbench/2326>\
**Category:** WorkBench Workflows\
**Tags:** Specify-7\
**Created:** [February 7, 2025, 8:39pm UTC](https://speciforum.org/t/create-collection-relationships-via-the-workbench/2326 "2025-02-07T20:39:19Z")\
**Posts on this page:** 3\
**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:** [February 7, 2025, 8:39pm UTC](https://speciforum.org/t/create-collection-relationships-via-the-workbench/2326/1 "2025-02-07T20:39:19Z")

</div>

> 📖 This guide walks through how to upload Collection Relationships through the WorkBench and includes screenshots of the mapping and what the uploaded results would be.

Collection relationships in Specify allow the association of specimens with other specimens in different collections. Examples include tissue-voucher, plant-pollinator, and host-parasite relationships. This functionality enables you to document these important connections, even across different disciplines, as long as the collections use the same catalog number format.

In Specify, one collection serves as the ‘Source’ and the other as the ‘Destination’. A source can have multiple destinations, but each destination can only have one source. For instance, if a bee pollinates several flowers, the bee collection is the source, and the flowers are the destinations.

Using the WorkBench, you can upload one or more [Collection Relationship](https://speciforum.org/t/collection-relationships/182) (CR) links for objects in your collection.

> [!warning]  
> Before proceeding, ensure you have configured [Collection Relationships](https://speciforum.org/t/create-a-collection-relationship-in-specify-7/1837) within your collection.
> 
> If you’re new to the **WorkBench** , please review the [WorkBench documentation](https://speciforum.org/t/the-specify-7-workbench/540).

## Steps to Upload Collection Relationships

1. **Access the WorkBench**  
Click on the **WorkBench** item in the navigation menu. Then, select **Create New** to initiate a new data set.

2. **Select Base Table**  
Choose **Collection Relationship** as the base table for your upload. You can also upload CR relationships with **Collection Object** as the base table, provided the CR is within the current collection. This is particularly useful when the Collection Objects (COs) already exist and you need to link them.

3. **Mapping and Data Set Example**  
Follow the prompts and begin to map your data correctly. The mapping can be as simple as a catalog number from the source collection and a catalog number from the destination collection, but you can use the full power of the WorkBench for mapping & configuration.  
You can refer to the examples below for guidance:

---

<div class="post-metadata">

**Author:** ![willem](https://avatars.discourse-cdn.com/v4/letter/w/898d66/32.png) [@willem](https://speciforum.org/u/willem)\
**Post date:** [February 10, 2025, 10:23am UTC](https://speciforum.org/t/create-collection-relationships-via-the-workbench/2326/2 "2025-02-10T10:23:35Z")

</div>

This is a great development, thank you! This is just what I need. It would be great to be able to validate the match between left and right sides, but I guess this could be done before importing the data (e.g. just using excel).

The concern is that the wrong catalogue number has been typed, and one would need to compare one or more fields on both sides of the collectionrelationship to be sure that the catalogue number is correct. Perhaps this just needs to become part of the broader workflow, where you would find a way to join data exported from the left side with data manually captured for importing into the right side. Only after validating would you then import the validated right-side data.

It may be an idea to think about ways to incorporate the validation step in the workbench application.

---

<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:** [August 26, 2025, 5:21pm UTC](https://speciforum.org/t/create-collection-relationships-via-the-workbench/2326/3 "2025-08-26T17:21:57Z")

</div>

2 posts were split to a new topic: [How to map fields for CO collection relationships in WorkBench](https://speciforum.org/t/how-to-map-fields-for-co-collection-relationships-in-workbench/2803)
