One Listbox for multiple FieldValues

[#1]

Hello,

hope someone can help me with the following question.

I´ve the following table "Categories":

ID	CategoryColor		CategorySize
1000	color	logo	size
1000	color	logo
1001	color		size
1002			size
1002	color	logo	size
1002	color	logo
1003
1004	color	logo	size

The problem is now I want to create ONE Listbox with all 3 Categories.

At the moment it´s only possible to create one Listbox for EACH category.

I think I have to create a new Field which contains AllCategories: color, logo, size and have to create a new table?! Maybe via subfield.

The problems therefore are the gaps by generating the new Field “AllCategories” in the table "Categories".

If would appreciate if someone could help.

Thanks

[Anonymous]

You should be able to use CrossTable to reformat the table the way you want

[#3]

Hey,

I think if I use crosstable the problem will be that the Table will get “new” ID´s. Consequently, the other problem would be that I also woudn´t know which ID´s have for example: color and size, size and logo,  or only color, …