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.
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.
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?
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.
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.
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.
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.
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.
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.
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.
