SELECT ENUMLIST DEPENDENT ON AN ENUMLIST USING BUTTON

[JuanIsidoro]

Hello, first of all thank you very much for allowing this question. And thanks in advance for your collaboration. I've been reading multiple help posts and I don't understand the error 😞
My problem is the following:

I need: SELECT ENUMLIST DEPENDENT ON AN ENUMLIST

I have the following tables:

1. Table: PRODUCTS table with the references: Options and Attributes
2. Table: ATTRIBUTES, with the id and the name
3. Table: TERMS, with the relationship between AttributesID and OptionsID

tables relation

This happens to me:
I select the Attribute, but it doesn't filter the values.

problem: not filter

I wish it were so. For ex.
I click on Color, and it shows the corresponding OptionsIDs.

The expression I am using to filter the TERMs is the following:

I hope someone can see if this is possible.
Thank you very much again!

[Joseph_Seddik]

Hola Juan,

The expression you should use is:

FILTER(Terms, [AtributosID] = [_ThisRow].[AtributosID])

Providing that OptionsID is the Key and Name is set as Lablel in the Terms table. 

[JuanIsidoro]

Buenas Joseph, mil gracias por tu respuesta!.
But I can't get it to work... 😞
I do not understand the problem...

Using Filter, I also tried it in multiple ways and I don't know what happens.

[JuanIsidoro]

I have passed the reference to LIST. But now it only compares when a single Attribute is pressed.

If I press 2, the Options button does not appear

The expression used is:

FILTER(Terms,LIST([AtributosID])=[_THISROW].[Atributos])

[Joseph_Seddik]

Hola Juan,

Please post screen shots of your tables from the editor. Thanks.

[JuanIsidoro]

Anything else you need, tell me.
Thank you very much!

Tabla Terms

Tabla Atributos

Tabla Productos

[Joseph_Seddik · Accepted solution]

Use this 🙂

FILTER(Terms, IN([AtributosID], [_ThisRow].[Atributos]))

[JuanIsidoro]

You are amazing! WORKS!
Thank you very much Joseph!!

I have tried several times with IN and I did not understand it well... Now I have advanced, I have understood this better.

Thank you very much for your help!!

[Joseph_Seddik]

Welcome my friend! The key is to read the guide carefully, sometimes more than once, then experiment 🙂

[JuanIsidoro]

Yes, yes, yes, read, I read! but the beginnings are difficult! LOL.
I follow your words.💪

THANK YOU!!