Multiple values in one field (display in a listbox)

[#1]

Hi everybody,

take a look at some example data:

id | company | categories
-------------------------------------------------------------
1000 | Apple | computer;mobile;advertising
1001 | Microsoft | computer;software
1002 | Dell | computer

As you can see, the field "categories" can have multiple items separeted by a semicolon.
Now I want to display the values in a listbox. But NOT this way:

Listbox:
------------
computer;mobile;advertising (1)
computer;software (1)
computer (1)

I want to show the values this way:

Listbox:
------------
computer (3)
mobile (1)
advertising (1)
software (1)

Could you help me please?

Thank,
jup

[biester · Accepted solution]

Hallo Juppinger,

I'd do it as in enclosed example.

Rgds,
Joachim