# Creating child records from the parent **URL:** \ **Category:** Ask for Help\ **Created:** [February 20, 2020, 3:17pm UTC](https://community.glideapps.com/t/creating-child-records-from-the-parent/4801 "2020-02-20T15:17:24Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![BobbyG77](https://avatars.discourse-cdn.com/v4/letter/b/85f322/32.png) [@BobbyG77](https://community.glideapps.com/u/BobbyG77)\ **Post date:** [February 20, 2020, 3:17pm UTC](https://community.glideapps.com/t/creating-child-records-from-the-parent/4801/1 "2020-02-20T15:17:24Z")
I am working on an app that tracks expenses incurred during trips. A trip can include one or more Customer(s). So, there is a one to many relationship between the trip (one) and customer (many) tables. I would like to be able to create first create a Job (call it Job 1). From within the Job 1 record, I’d like to be able to add Customers. I have 3 worksheets that contain: Jobs, Customers and Job/Customers, with relations between Jobs and Job/Customers and between Customers and Job/Customers. Once I have created Job 1, I would like to be able to press a Add Customer form button where I can simply select a Customer from the Customers table using a Choice component. So, from Job 1, I’d like to be able to add Customer A, Customer B, Customer C, etc. Is there a way to simply select Customer A, then (using the same button) select Customer B, etc. - without also having to select Job 1 every time? The entries being made go to the Job/Customers table as: **Job ID Customer** Job 1 Customer A Job 1 Customer B Job 1 Customer C How do I set this up so that the Job 1 side of the entry is automatically passed over to the table? ---
**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:** [February 20, 2020, 4:41pm UTC](https://community.glideapps.com/t/creating-child-records-from-the-parent/4801/2 "2020-02-20T16:41:32Z")
If you put a form button on your job details screen you can click on it to open the the form, place a choice component on the screen for the list of customers, and use the column value components to automatically include the job. Clicking submit will write a record with the automatically pulled job and the selected customer to the the job/customer sheet. ---
**Author:** ![BobbyG77](https://avatars.discourse-cdn.com/v4/letter/b/85f322/32.png) [@BobbyG77](https://community.glideapps.com/u/BobbyG77)\ **Post date:** [February 20, 2020, 4:48pm UTC](https://community.glideapps.com/t/creating-child-records-from-the-parent/4801/3 "2020-02-20T16:48:31Z")
That did it! I didn’t understand the purpose of column values until now. Thank you sir! ---
**Author:** ![BobbyG77](https://avatars.discourse-cdn.com/v4/letter/b/85f322/32.png) [@BobbyG77](https://community.glideapps.com/u/BobbyG77)\ **Post date:** [February 20, 2020, 4:54pm UTC](https://community.glideapps.com/t/creating-child-records-from-the-parent/4801/4 "2020-02-20T16:54:33Z")
Could I ask one more thing? What would be the best way to display the customers associated with the Job on the Job detail view? ---
**Author:** ![BobbyG77](https://avatars.discourse-cdn.com/v4/letter/b/85f322/32.png) [@BobbyG77](https://community.glideapps.com/u/BobbyG77)\ **Post date:** [February 20, 2020, 5:01pm UTC](https://community.glideapps.com/t/creating-child-records-from-the-parent/4801/5 "2020-02-20T17:01:04Z")
To clarify, I’d like to display a list of customers associated with the Job below the Add Customer to this Job form button. ---
**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:** [February 20, 2020, 5:11pm UTC](https://community.glideapps.com/t/creating-child-records-from-the-parent/4801/6 "2020-02-20T17:11:33Z")
Check out Multi-Level Select in [https://concepts.glideapp.io/](https://concepts.glideapp.io/). I think that is very similar to what you want minus the choice component part of it.