# Add multiple Projects to an Employee (and viceversa) on Layout

**URL:** <https://community.glideapps.com/t/add-multiple-projects-to-an-employee-and-viceversa-on-layout/78360>\
**Category:** Ask for Help\
**Created:** [December 4, 2024, 6:01pm UTC](https://community.glideapps.com/t/add-multiple-projects-to-an-employee-and-viceversa-on-layout/78360 "2024-12-04T18:01:15Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![axltrauts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/axltrauts/32/82701_2.png) [@axltrauts](https://community.glideapps.com/u/axltrauts)\
**Post date:** [December 4, 2024, 6:01pm UTC](https://community.glideapps.com/t/add-multiple-projects-to-an-employee-and-viceversa-on-layout/78360/1 "2024-12-04T18:01:15Z")

</div>

**EDIT: I am using Big Tables. I found that Lookup is not available 🫠**

I have an Employee table. I have a Project Table. I want to be able to Add an employee with the Add button and Edit an employee with the Edit Button, where I can select multiple Projects for him, using the Add and Edit forms on the Layout.

In the Project Layout, I want to be able to add one or many existing Employees.

I really thought that should be simple, but no. I cannot find any use with Choice, or any other components. I saw the Glide Certifications 1-3 with no success. What am I doing wrong?

---

<div class="post-metadata">

**Author:** ![axltrauts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/axltrauts/32/82701_2.png) [@axltrauts](https://community.glideapps.com/u/axltrauts)\
**Post date:** [December 4, 2024, 6:53pm UTC](https://community.glideapps.com/t/add-multiple-projects-to-an-employee-and-viceversa-on-layout/78360/2 "2024-12-04T18:53:32Z")

</div>

I found a 3 year old Many to Many relations ([here](https://www.youtube.com/watch?v=vJfgz3oOp4w)) and well… It won’t work for me because it uses Lookup 🫠

I’m just 4 days into Glide. Am I still in time to look for an alternative? I really think it is something normal to relate using Layouts and not from the Data editor, as every single Glide video shows.

---

<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:** [December 5, 2024, 12:21am UTC](https://community.glideapps.com/t/add-multiple-projects-to-an-employee-and-viceversa-on-layout/78360/3 "2024-12-05T00:21:40Z")

</div>

![CleanShot 2024-12-05 at 07.21.20](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/2/42b53f8129d72f0f59f6a4044fc77f6a9337e5eb.png)

Please check the list of limitations for Big Tables.

> **[Big Tables | Glide Docs](https://www.glideapps.com/docs/big-tables#limitations-of-big-tables)**
>
> Scale your app with up to 10 million rows of data.

---

<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:** [December 5, 2024, 12:22am UTC](https://community.glideapps.com/t/add-multiple-projects-to-an-employee-and-viceversa-on-layout/78360/4 "2024-12-05T00:22:58Z")

</div>

My first question would be do you need Big Tables for your app? Is it safe to assume you are storing a huge number of records?

---

<div class="post-metadata">

**Author:** ![axltrauts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/axltrauts/32/82701_2.png) [@axltrauts](https://community.glideapps.com/u/axltrauts)\
**Post date:** [December 6, 2024, 2:16am UTC](https://community.glideapps.com/t/add-multiple-projects-to-an-employee-and-viceversa-on-layout/78360/5 "2024-12-06T02:16:57Z")

</div>

Boom! Yes, I missed completely the Linked Glide Table. I thought it had to do with linking to other source. Anyways, this is my free plan testing Glide and looking to see if it fits for a business case. Thanks ThinDinh!