# Inline Table separate arrays
**URL:** https://community.glideapps.com/t/inline-table-separate-arrays/75718
**Category:** Ask for Help
**Created:** [August 19, 2024, 11:21am UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718 "2024-08-19T11:21:40Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@AJ-SuD](https://community.glideapps.com/u/AJ-SuD)
#### Post date: [August 19, 2024, 11:21am UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/1 "2024-08-19T11:21:40Z")
Hi Community,
i’m trying to list potential suppliers in an inlnetable.
What I’ve done so far…
I created a DataTable named “generator”, where the inputs are stored from the possible variations which are kept in an other product table. In that called “Matrix” table if have boelean checkboxes for each supplier and for each supplier an “if the else” to show it’s companyname, the problem is i can’t separate the companynames into different rows.
Generator
matrix
Any ideas how to solve my problem?
Kind regards,
Alex
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 19, 2024, 1:24pm UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/3 "2024-08-19T13:24:15Z")
Do you already have a table that lists the company names? You can use that matrix array of company names and create a relation to the companies table. Then you can use the relation as the source of collection.
---
### Author:  [@AJ-SuD](https://community.glideapps.com/u/AJ-SuD)
#### Post date: [August 19, 2024, 1:49pm UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/4 "2024-08-19T13:49:31Z")
Yes i do
But i’m working with 3 tables
Navigation is based on the table “generator”
where I select the variations with dropdowns from the “matrix” table.
The companies are related in the "matrix"table to the “companies” table.
Do I have to create a relation in the generator table as well?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 19, 2024, 3:06pm UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/5 "2024-08-19T15:06:29Z")
Could you use a single value column to bring the matrix array into the generator table, and then build your relation? I guess I’m not following how your matrix array is created in the first place, so you may or may not be able to use a Lookup column instead.
---
### Author:  [@AJ-SuD](https://community.glideapps.com/u/AJ-SuD)
#### Post date: [August 20, 2024, 8:30am UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/6 "2024-08-20T08:30:56Z")
Good morning Jeff,
somehow the single Value won’t split in different rows.
Here you’ll see the dependencies and what I’ve done.
with this step i’ll find out the unique row number from the matrix table.
Matrix table signing values for each row
Single Value is correct look at the booleans
Funny as writing the Post the result is correct now 🙂
Thanks for helping
Alex
---
### Author:  [@AJ-SuD](https://community.glideapps.com/u/AJ-SuD)
#### Post date: [August 21, 2024, 5:28am UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/7 "2024-08-21T05:28:06Z")
Good morning Jeff
is it correct, selecting thr single value as source?
Assumed I’d like to show a dropdown with employees belonging to the company, which are stored in an other DataTable when adding an other item to tha table.
That won’t be possible or will it?
Thank’s
Alex
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 21, 2024, 5:26pm UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/8 "2024-08-21T17:26:59Z")
I’m a little lost with how you have everything set up. Overall, my goal would be to get a column with an array of all companies that match your selection criteria in the generator table. Using that array, I would then create a relation linking it to the companies table.
I was initially thinking a Single Value column, but it appears that your matrix table uses multiple rows, so it would probably involve a lookup column to get an array of matching companies into the generator table.
Sorry, I have vacation brain right now, so I’m not putting a lot of thought into it.
---
### Author:  [@AJ-SuD](https://community.glideapps.com/u/AJ-SuD)
#### Post date: [August 27, 2024, 1:38pm UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/9 "2024-08-27T13:38:35Z")
Hi Jeff,
have a nice vacation!
I’ve found a way to list the matching companies directly through the sourceTable “Kreditor” without selecting the single value column as source like I had before.
The filtering option did the rest.
Now my problem is showing the corresponding Contacts in a dropdownlist.
Whatever I’m doing all the contacts from all companies are selectable but not split apart.
I’d like only one Name to be selectable for Freytag -\>… Figuei…or Meurer
For Thyss… → Leithe… etc.
What am I doing wrong?
Thanks Alex
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 28, 2024, 12:04am UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/10 "2024-08-28T00:04:56Z")
So what you’re showing there is a choice component, and you want only contacts related to Freytag & Petersen to show in that component?
---
### Author:  [@AJ-SuD](https://community.glideapps.com/u/AJ-SuD)
#### Post date: [August 28, 2024, 5:23am UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/11 "2024-08-28T05:23:37Z")
Good morning ThinhDinh,
yes correct, in a dropdown to select the contacts individual.
company1 →
- comp1contact1 ✅
- comp1contact2
company2 →
- comp2contact1
- comp2contact2
- comp2contact3 ✅
Thank you
Alex
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 28, 2024, 8:21am UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/12 "2024-08-28T08:21:01Z")
Sorry I haven’t followed this thread closely. Are you storing those contacts as separate rows in another table?
---
### Author:  [@AJ-SuD](https://community.glideapps.com/u/AJ-SuD)
#### Post date: [August 28, 2024, 8:41am UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/13 "2024-08-28T08:41:55Z")
yes
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 28, 2024, 8:56am UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/14 "2024-08-28T08:56:06Z")
Then if you can estabish a multiple relation between companies table to contacts table, you can use that relation as the source of your choice component.
---
### Author:  [@AJ-SuD](https://community.glideapps.com/u/AJ-SuD)
#### Post date: [August 28, 2024, 9:27am UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/15 "2024-08-28T09:27:44Z")
i have a multiple relation established in companies Table “Kreditor” connected to the contacts table “Ansprechpartner” .
In the dropdown Data \> source, i can’t see a ralation entry.
Thank you
Alex
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 28, 2024, 11:46am UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/16 "2024-08-28T11:46:00Z")
What is the component you are using here?
---
### Author:  [@AJ-SuD](https://community.glideapps.com/u/AJ-SuD)
#### Post date: [August 28, 2024, 12:01pm UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/17 "2024-08-28T12:01:55Z")
it’s a table component as shown on the last picture
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 28, 2024, 2:46pm UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/18 "2024-08-28T14:46:47Z")
How did you configure the “selected…” column for it to look like that? Can you click on it and show me your configuration? Thank you.
---
### Author:  [@AJ-SuD](https://community.glideapps.com/u/AJ-SuD)
#### Post date: [August 30, 2024, 6:12am UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/19 "2024-08-30T06:12:59Z")
Good morning ThinhDinh,
Alex
---
### Author:  [@AJ-SuD](https://community.glideapps.com/u/AJ-SuD)
#### Post date: [September 4, 2024, 2:03pm UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/20 "2024-09-04T14:03:03Z")
Hi ThinhDinh,
as I read in the forum, it is not possible to assign a dropdown element to an inline element that receives its data from an array or a composite cell like template or split txt etc… in order to display the entries individually selectable.
It would only work if the data comes from one column…
Also with Robert\_Petittos MIRACLE METHOD
I probably wouldn’t get the correct data displayed because I can’t assign a filter to the dropdown itself.
Please correct me if I’m wrong there.
The solution, which is even clearer in its presentation…
I have now added an intermediate step.
An inline button inside the inlinelist that writes the supplier row ID into a USC field via action and which also opens a new screen for this Item
There i can setup the last settings for the inquery.
Thank’s a lot @all for helping me!
Alex
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 4, 2024, 2:51pm UTC](https://community.glideapps.com/t/inline-table-separate-arrays/75718/21 "2024-09-04T14:51:08Z")
Thanks, now I understand your problem better. Admittedly I have never tried a dynamic thing like that myself, but can you verify that under Data \> Source you can not assign a relation? Sorry I’m not at my computer to test.
[Next page](https://community.glideapps.com/t/inline-table-separate-arrays/75718.md?page=2)