Select 2 display in Browse form Topic is solved

[nc07]

Hi,

How can i display select 2 multiselect data. At the moment it displays in array format eg

Code: Select all

["0","1"]

.

i want it to display as 0,1 etc only. How can this be achieved?

[kev1n]

Hi,

How many distinct values are there? Are they stored a list 0|something|1|something2 or retrieved by SQL from another table?

[nc07]

Hi,

How many distinct values are there? Are they stored a list 0|something|1|something2 or retrieved by SQL from another table?

At the moment two values and its a stored list

[kev1n]

If it's just 2 values, do a replace

E.g.

Code: Select all

REPLACE(REPLACE(your_column,'1','something'),'2','something else')

[nc07]

If it's just 2 values, do a replace

E.g.

Code: Select all

REPLACE(REPLACE(your_column,'1','something'),'2','something else')

How is it achievable if there are more than 2 values

[kev1n]

If the values are stored in an other table:

viewtopic.php?p=16613

[nc07]

If the values are stored in an other table:

viewtopic.php?p=16613

Thanks for your quick response, i will try your suggestions and let you know how it goes.

Thanks Kevin

[nc07]

Thanks, Kevin, Both the suggestions worked well. Best Regards.