# Can Master-Detail be done in one flow?

**URL:** <https://connective.celigo.com/t/can-master-detail-be-done-in-one-flow/635>\
**Category:** Integrator.io\
**Tags:** microsoft-sql, integration-app, flow-builder, salesforce\
**Created:** [September 29, 2022, 6:49pm UTC](https://connective.celigo.com/t/can-master-detail-be-done-in-one-flow/635 "2022-09-29T18:49:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeffstevens](https://avatars.discourse-cdn.com/v4/letter/j/ecae2f/32.png) [@jeffstevens](https://connective.celigo.com/u/jeffstevens)\
**Post date:** [September 29, 2022, 6:49pm UTC](https://connective.celigo.com/t/can-master-detail-be-done-in-one-flow/635/1 "2022-09-29T18:49:12Z")

</div>

I'm doing integrations from SQL Server to Salesforce. Can I do a master-detail integration in one flow?

I have two tables in the SQL server (po\_hdr, po\_ilne), and plan to integrate those to the Salesforce PO\_HDR and PO\_LINE objects.

Do I need two separate flows for that or can it be done in one flow?

---

<div class="post-metadata">

**Author:** ![scotthenderson](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/scotthenderson/32/6780_2.png) [@scotthenderson](https://connective.celigo.com/u/scotthenderson)\
**Post date:** [October 17, 2022, 4:00pm UTC](https://connective.celigo.com/t/can-master-detail-be-done-in-one-flow/635/2 "2022-10-17T16:00:58Z")

</div>

There are multiple ways to do this.

1. See pic below. There is a 'composite' option that might allow you to do this in 1 single flow and only 1 single import bubble.
2. Else, you can use 2 import bubbles in 1 single flow, where the first bubble imports the parent records, and the second bubble imports the child records.
3. Else, you can use 2 flows to completely separate the parent vs child imports.

 ![5301043caa20740200000001-0a810c10653740a1ac682c1936466605.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/4488a4e17fc803dba88d67b03d8ad2afe8e597fc.png)