# Copy data between 2 tables

**URL:** https://community.glideapps.com/t/copy-data-between-2-tables/77434
**Category:** Ask for Help
**Created:** [October 29, 2024, 5:23am UTC](https://community.glideapps.com/t/copy-data-between-2-tables/77434 "2024-10-29T05:23:07Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![ronen.regev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ronen.regev/32/81310_2.png) [@ronen.regev](https://community.glideapps.com/u/ronen.regev)
#### Post date: [October 29, 2024, 5:23am UTC](https://community.glideapps.com/t/copy-data-between-2-tables/77434/1 "2024-10-29T05:23:07Z")

</div>

Hi.  
I need to update a field in one table (“Target table”) with data from a field in another table (“Source table”).  
I tried to do it with an action in a collection component, as explained in some guides, using “Set column values” triggered by selecting a row in the list, but the fields (columns) I can select to update are only from the “Source table”, although I build the component in the detail page of the “Target table”.  
Do any Glide experts can help me with that?  
Thanks alot

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 29, 2024, 5:25am UTC](https://community.glideapps.com/t/copy-data-between-2-tables/77434/2 "2024-10-29T05:25:07Z")

</div>

You need to create a Single Relation from the source table to the target table, then you can Set Column Values through that relation.