Passing multiple values

[Anonymous]

Hello all

I have 2 Listboxs, one called 'Colours 1' and the other called 'Colours 2' and there is no relationship between the two tables.

I select 3 colours from 'Colours 1'. How can i make 'Colours 2' reflect the selections i made in 'Colours 1'????

Hope somebody can help, it's driving me nuts!!!!!!

[Miguel_Angel_Baeyens]

Hello Robbie,

Just a bit more tweaking about the same

='(' & Concat(Replace(Colour, ' ', '*'), '|') & ')'

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[Anonymous]

Miguel you are a genius!!! This has really saved me time. Just one more thing.

What if i have Blue&Grey ?

I have tried this but it doesn't work...

'(' & Concat(Replace(Replace(Colour, ' ', '*')Colour, '&', '*'), '|') & ')'

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

It's all in the syntax

='(' & Concat(Replace(Replace(Colour, ' ', '*'), '&', '*'), '|') & ')'

You can next several Replace() functions, but depending on all possible values, it may be worth cleaning the code in the script, so you have a field with the name to show and other field with the name clean to operate with.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[Anonymous]

Many thanks for the time you have given.