# Accessing a rowid from a parent and inserting into child automatically
**URL:** https://community.glideapps.com/t/accessing-a-rowid-from-a-parent-and-inserting-into-child-automatically/80425
**Category:** Ask for Help
**Created:** [March 1, 2025, 3:54pm UTC](https://community.glideapps.com/t/accessing-a-rowid-from-a-parent-and-inserting-into-child-automatically/80425 "2025-03-01T15:54:51Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@alan\_singer](https://community.glideapps.com/u/alan_singer)
#### Post date: [March 1, 2025, 3:54pm UTC](https://community.glideapps.com/t/accessing-a-rowid-from-a-parent-and-inserting-into-child-automatically/80425/1 "2025-03-01T15:54:51Z")
I have table called people and the rows in this table are parent rows to rows from another table called notes
I have a table of notes that can be added and are related to one or a number of people records
I want to be able to fill in the child record without having to add the related people record via a drop down - I am hoping I can do it as part of the on-submit workflow when writing or updating the child (note) row.
Here is how I am doing it at the moment by manually selcting the key of the parent row to which the notes row relates
(I relaise I can only automatiically add the rowid of the person for whom I am adding the note and to add other parents, to the note row, I would need to do that manually
But i would like to have the row for which the note is originally created have the foreign key populated automatically
To do this I know I will somehow need access to the parent row at the time of submitting the child row - But how to do that?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 1, 2025, 5:16pm UTC](https://community.glideapps.com/t/accessing-a-rowid-from-a-parent-and-inserting-into-child-automatically/80425/2 "2025-03-01T17:16:24Z")
So the note will initially be assigned to only one user? You can can just add a column component to the form which grabs values from the parent row and passes them through the form automatically.
---
### Author:  [@alan\_singer](https://community.glideapps.com/u/alan_singer)
#### Post date: [March 2, 2025, 1:39pm UTC](https://community.glideapps.com/t/accessing-a-rowid-from-a-parent-and-inserting-into-child-automatically/80425/3 "2025-03-02T13:39:01Z")
Thanks for your reply @Jeff_Hager.
You said
“You can can just add a column component to the form which grabs values from the parent row and passes them through the form automatically.”
So I add a column componenet (Text?) to the Note (?) form…Can you pls help me understand what I need to do to have this note column grab values from the parent row?
…at what stage does it grab the row ? And what needs to be done to make that happen - I was uable to see the parent row from the workflow that was possible to do after the submit of teh note row.
Right now I am using a choice field into which t the user has to enter a search term then chooses the correct person name.
If you can please go to the next level of detail - the how would be great
Thanks
Alan
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 2, 2025, 2:26pm UTC](https://community.glideapps.com/t/accessing-a-rowid-from-a-parent-and-inserting-into-child-automatically/80425/4 "2025-03-02T14:26:17Z")
> **[Column Values | Glide Docs](https://www.glideapps.com/docs/reference/values/column-values#column-values-in-submission-screens)**
>
> Column values are the values contained in your data source tables.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [March 9, 2025, 2:27pm UTC](https://community.glideapps.com/t/accessing-a-rowid-from-a-parent-and-inserting-into-child-automatically/80425/5 "2025-03-09T14:27:09Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.