---
title: "Joining Two Objects To Be Displayed On A Form"
slug: "joining-two-objects-to-be-displayed-on-a-form"
updated: 2021-03-12T15:05:26Z
published: 2021-03-12T15:07:13Z
canonical: "documentation.decisions.com/joining-two-objects-to-be-displayed-on-a-form"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Joining Two Objects To Be Displayed On A Form

Example Lab ArticleWhile Example Lab projects are resources for public use, articles and assets are not actively maintained. Screenshots and features are from the specified version below. These references may become dated as new versions are released.

---

## Overview

| ## Example Lab Details |
| --- |
| **Version** | 6.10.1 |
| **Root Folder** | ExampleLab.TwoObjectJoin |
| **Modules** | None |
| **Dependencies** | None |

This project serves as an example of joining two database stored structures together to be displayed on a Form in a data grid.

---

## Explanation

This Flow will use a RawSQL Join to combine two database stored objects into a simple Flow structure. In order to make this join successful, we have added an ID field to both of our structures that will save a relating ID when the items are created. Once items are paired and the resulting structure is built, the structure will then be passed to the Form to be displayed on a data grid component. This project contains a set up flow, which will need to be run prior to the Main Flow. This stages data on the database in order for the join to be successful.

Reference Articles[https://documentation.decisions.com/docs/editing-data-grid-items-with-the-property-grid](https://documentation.decisions.com/docs/editing-data-grid-items-with-the-property-grid)  
[https://documentation.decisions.com/docs/raw-sql-step](https://documentation.decisions.com/docs/raw-sql-step)

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/921085276ef5e3254a7d8a48160c05d6.png)

---

## Project Download

The examples attached were developed to be instructional and were not developed as officially supported components. For more information or to engage our service team to develop fully supported, production quality solutions, please contact services@decisions.com. Import the project below to a Decisions environment on version 6.10.1 or later using our [Importing/Exporting](https://documentation.decisions.com/docs/exporting-and-importing-overview) article.  
  
[ExampleLab.TwoObjectJoin.zip](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/ExampleLab.TwoObjectJoin.zip)  

---