# Parent/Child Relationship **URL:** \ **Category:** Ask for Help\ **Created:** [April 16, 2024, 7:39pm UTC](https://community.glideapps.com/t/parent-child-relationship/72633 "2024-04-16T19:39:06Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![louie.aldons-locke](https://avatars.discourse-cdn.com/v4/letter/l/c37758/32.png) [@louie.aldons-locke](https://community.glideapps.com/u/louie.aldons-locke)\ **Post date:** [April 16, 2024, 7:39pm UTC](https://community.glideapps.com/t/parent-child-relationship/72633/1 "2024-04-16T19:39:07Z")
Hi All, I am creating a logging system which will be used within an Event Control Room. The system will log all calls and radio messages inbound and outbound. That being said, by the nature of what this function does, a user should not be able to edit a call once it has been logged, only add updates. I have 2 tables: 1. Call details _this records all of the information from the initial call_ 2. Call updates _this records updates for the call_ I need a way to link the two tables together so that the updates for Call 1 only show for Call 1 and the updates for Call 2 only show for Call 2 etc etc. Is there a way to achieve this? TIA! ![Screenshot 2024-04-16 at 20.36.44](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/1583379d7d73f00609e41cb83dc3e73f1adac15e.jpeg) ![Screenshot 2024-04-16 at 20.36.48](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e6b23bf93b5b1c394751c9a9835f0b0d5db19c27.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 16, 2024, 7:59pm UTC](https://community.glideapps.com/t/parent-child-relationship/72633/2 "2024-04-16T19:59:12Z")
As long as you have a common value in both tables, such as a Call ID, you can create a relation in the Call table linking it to the Updates table. With that relation, you can have a collection of Updates in the Call Detail Screen sourced from the relation. ---
**Author:** ![louie.aldons-locke](https://avatars.discourse-cdn.com/v4/letter/l/c37758/32.png) [@louie.aldons-locke](https://community.glideapps.com/u/louie.aldons-locke)\ **Post date:** [April 17, 2024, 6:35am UTC](https://community.glideapps.com/t/parent-child-relationship/72633/3 "2024-04-17T06:35:36Z")
Sounds like this is exactly what I need! I’m looking at making a sequential counter for Call Reference. This would be the field in each table. Could you advise on a simple sequential counter? ---
**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:** [April 17, 2024, 7:51am UTC](https://community.glideapps.com/t/parent-child-relationship/72633/4 "2024-04-17T07:51:48Z")
For the sequential counter, take a look at the video in the below doc: > **[Make | Glide Docs](https://www.glideapps.com/docs/automation/integrations/make)** > > Integrate 1600+ tools with your app. ---
**Author:** ![louie.aldons-locke](https://avatars.discourse-cdn.com/v4/letter/l/c37758/32.png) [@louie.aldons-locke](https://community.glideapps.com/u/louie.aldons-locke)\ **Post date:** [April 18, 2024, 1:00pm UTC](https://community.glideapps.com/t/parent-child-relationship/72633/5 "2024-04-18T13:00:58Z")
Thanks, do I have to do this through a third party? Is there not a way I can do this within Glide? ---
**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:** [April 18, 2024, 1:12pm UTC](https://community.glideapps.com/t/parent-child-relationship/72633/6 "2024-04-18T13:12:45Z")
It depends. Glide does not do atomic operations, so if it is essential that you should never have duplicates, then you should use the solution shown in the video. Otherwise, see below: > [@How do I create an auto-incrementing row number with Glide Tables?](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572): > > This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time… ---
**Author:** ![louie.aldons-locke](https://avatars.discourse-cdn.com/v4/letter/l/c37758/32.png) [@louie.aldons-locke](https://community.glideapps.com/u/louie.aldons-locke)\ **Post date:** [April 18, 2024, 1:16pm UTC](https://community.glideapps.com/t/parent-child-relationship/72633/7 "2024-04-18T13:16:23Z")
Sorry to reply again, @Jeff_Hager. Is it possible you can better explain your solution here? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 18, 2024, 3:11pm UTC](https://community.glideapps.com/t/parent-child-relationship/72633/8 "2024-04-18T15:11:34Z")
Here is the documentation on creating a relation between two tables. [https://www.glideapps.com/docs/automation/computed-columns/relations](https://www.glideapps.com/docs/automation/computed-columns/relations) Here is documentation on Collections. The source of a collection can be set to the relation on the Call Details screen. > **[Collections | Glide Docs](https://www.glideapps.com/docs/essentials/components/collections)** > > Show lists of items from your tables in different layouts. Review the documentation and let us know if you are still not understanding something. ---
**Author:** ![louie.aldons-locke](https://avatars.discourse-cdn.com/v4/letter/l/c37758/32.png) [@louie.aldons-locke](https://community.glideapps.com/u/louie.aldons-locke)\ **Post date:** [April 19, 2024, 12:00pm UTC](https://community.glideapps.com/t/parent-child-relationship/72633/9 "2024-04-19T12:00:07Z")
Thanks, Jeff. The thing I’m not understanding… I am using ‘ROW ID’ as the unique reference for each new ‘Call’ being logged. This is in the ‘General Call’ data sheet. I can’t work out how the call ID is copied across to the ‘Call Updates’ data sheet to ensure that only updates that are added from that calls page are shown. I hope this makes sense? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 19, 2024, 12:49pm UTC](https://community.glideapps.com/t/parent-child-relationship/72633/10 "2024-04-19T12:49:33Z")
When you use your Add Updates form to add call updates, you can add various Value components to the same form to pass various values from the current parent Call Detail row into the newly added Call Update row. Choose the appropriate Value component to add to your form and set it to write the Call ID into a column in your Call Updates table. That’s the column that your relation will use.