# I have a complicated scenario

**URL:** <https://community.glideapps.com/t/i-have-a-complicated-scenario/41570>\
**Category:** Ask for Help\
**Created:** [May 3, 2022, 7:52am UTC](https://community.glideapps.com/t/i-have-a-complicated-scenario/41570 "2022-05-03T07:52:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\
**Post date:** [May 3, 2022, 7:52am UTC](https://community.glideapps.com/t/i-have-a-complicated-scenario/41570/1 "2022-05-03T07:52:13Z")

</div>

I am preparing app for **Inspections**

The given as follows:

1. Companies has many projects.

2. Each project has many disciplines (Architectural (A), Structure (S), etc) These discipline varies from project to project.

The Inspection No. Should appear like [{Discipline abbreviation}-FIR-{incremental number depends on the max number for each discipline}

**The Good News is**  
i managed to segregate and count each Project-Discipline and able to count them separately. and i have the required inspection No in its final format at Discipline table, As Shown in the below photo

 ![Glide Discipline](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/4/34f33c1e49e7d78cf4b2121404ff491c4512792e.jpeg).

i also managed to bring the values to the Inspection request table (where the Form is built) Thus via a lookup column. As Shown below

 ![Glide Inspection Request](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/db20588dfb172282206bb8a72a7948238d8e339e.jpeg)

**The Bad News is**  
i am not able to use this values in my Form, it is not showing as available values for text box or even choice component.

I think i am missing something here. Can you please support me in that.

Thank you

---

<div class="post-metadata">

**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:** [May 3, 2022, 8:10am UTC](https://community.glideapps.com/t/i-have-a-complicated-scenario/41570/2 "2022-05-03T08:10:29Z")

</div>

Your Lookup column appears as an array, which indicates that your relation is a multi-relation. You probably need to change that to a single relation.

---

<div class="post-metadata">

**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\
**Post date:** [May 3, 2022, 8:16am UTC](https://community.glideapps.com/t/i-have-a-complicated-scenario/41570/3 "2022-05-03T08:16:13Z")

</div>

i will study the difference, since i joined Glide since 3 days only. but i will try to read more about that and how to establish that.

Thank you for your kind respected reply.  
By the way, thank you for your video explaining the incremental number for new user.  
[[Unique Numbers - #7 by Waser\_I\_Solutions](https://community.glideapps.com/t/unique-numbers/35039/7)]

---

<div class="post-metadata">

**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\
**Post date:** [May 3, 2022, 9:26am UTC](https://community.glideapps.com/t/i-have-a-complicated-scenario/41570/4 "2022-05-03T09:26:28Z")

</div>

Darren, Thank you so so much, it works like magic. for each and ever project and every discipline independently.

Really Thank you ❤

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 4, 2022, 9:27am UTC](https://community.glideapps.com/t/i-have-a-complicated-scenario/41570/5 "2022-05-04T09:27:27Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.