how to get a list from a selection

[Gael31]

I have a table of type
col1 col2 col3
name1 note1 age2
name2 note2 age1
name1 note3 age3

I would like to select in the choices of col1 the value name1 to bring out in a table all the values corresponding to this thread of col2 namely note1 and note3.

Can you help me?

[jwjackso · Accepted solution]

The default behavior when you select 'name1' is to only display 'note1' and 'note3'.  If you want to create a list of the available values for col2, use the Concat() function.

[Gael31 · Accepted solution]

Thank you very much !