# Is there a way to create child records when using Airtable

**URL:** <https://community.glideapps.com/t/is-there-a-way-to-create-child-records-when-using-airtable/44503>\
**Category:** Ask for Help\
**Created:** [July 15, 2022, 12:16am UTC](https://community.glideapps.com/t/is-there-a-way-to-create-child-records-when-using-airtable/44503 "2022-07-15T00:16:18Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matthew\_Saragusa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matthew_saragusa/32/41386_2.png) [@Matthew\_Saragusa](https://community.glideapps.com/u/Matthew_Saragusa)\
**Post date:** [July 15, 2022, 12:16am UTC](https://community.glideapps.com/t/is-there-a-way-to-create-child-records-when-using-airtable/44503/1 "2022-07-15T00:16:18Z")

</div>

I’m having trouble creating relations with airtable.

I have two tables, Contract and ContractItems

This is how i’ve set up Airtable.  
I have populated Contracts and (in Airtable) and created a relation between Contracts and ContractItems. One contract can have many contractitems, but a contractitem can only have one contract.

Glide recognizes this relationship and shows the relationship in tables automatically when it imported the datasets, but I cannot figure out how to create those relations in Glide forms.

I cannot figure out how to add a ContractItem from the Contracts page. When using google sheets, I normally just drop a button with a “Form Action” and use column data to populate the ContractItem column’s ID. I can’t figure out how to do this with Airtable because Airtable has a relationship column, not an ID column to reference it’s parent.

Does anyone know how to do this?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 15, 2022, 12:44am UTC](https://community.glideapps.com/t/is-there-a-way-to-create-child-records-when-using-airtable/44503/2 "2022-07-15T00:44:46Z")

</div>

@Robert_Petitto is this something you refer to as “linked records” in Airtable?

With Glide, I usually do this in 2 steps, creating the parent record first, then in the parent record’s details view, have a form to create child records. I usually link them by passing the parent record’s rowID to the child record’s row.

---

<div class="post-metadata">

**Author:** ![Matthew\_Saragusa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matthew_saragusa/32/41386_2.png) [@Matthew\_Saragusa](https://community.glideapps.com/u/Matthew_Saragusa)\
**Post date:** [July 15, 2022, 12:48am UTC](https://community.glideapps.com/t/is-there-a-way-to-create-child-records-when-using-airtable/44503/3 "2022-07-15T00:48:16Z")

</div>

Yes, linked records, but Airtable doesn’t use IDs to link the records. The field is not a text box, it’s a relation.

Also, i can’t figure out how to link them in glide. The column which links the tables (in Airtable) is not available in Glide.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [July 15, 2022, 1:03am UTC](https://community.glideapps.com/t/is-there-a-way-to-create-child-records-when-using-airtable/44503/4 "2022-07-15T01:03:08Z")

</div>

Correct. The number one issue with using Airtable as your base is that you can’t write to a link field. This means you can’t use Airtable as a relational database and instead you must use it like a normal spreadsheet. Until Glide can write to a link field, it’s really tedious to build workarounds.

---

<div class="post-metadata">

**Author:** ![Matthew\_Saragusa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matthew_saragusa/32/41386_2.png) [@Matthew\_Saragusa](https://community.glideapps.com/u/Matthew_Saragusa)\
**Post date:** [July 15, 2022, 1:11am UTC](https://community.glideapps.com/t/is-there-a-way-to-create-child-records-when-using-airtable/44503/5 "2022-07-15T01:11:27Z")

</div>

I have an app that I’m using for production management where users are pushing live updates as they complete different tasks of production.

Management wants reports of what’s been completed and how much has been completed in each step. Airtable does a great job of creating all the different data views which would work extremely well in this respect.

This stack would be amazing if they could implement the airtable relations in glide

---

<div class="post-metadata">

**Author:** ![Marcus1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marcus1/32/47961_2.png) [@Marcus1](https://community.glideapps.com/u/Marcus1)\
**Post date:** [September 18, 2022, 12:56am UTC](https://community.glideapps.com/t/is-there-a-way-to-create-child-records-when-using-airtable/44503/6 "2022-09-18T00:56:24Z")

</div>

Has this been resolved?
