list box

[nareshthavidishetty]

Hi,

How to show two different fields of same table in an single listbox.

Thanks..

[Chanty4u]

can you explain more?

[avinashelite]

Try like this

Add an expression like

Field1&'-'&Field2

etc

[Chanty4u]

Do Concatenation in script  &'-'&

[nareshthavidishetty]

Hi ,

The fields were

-> Product

-> Category

I need to show with in single list box as,

Product

Category

Thanks..

[avinashelite]

in front end .

Go to Listbox >general> select the expression option in the field selection > and add this expression

Product&','&Category

if you need to link all the Category to respective Product group then try like this

Temp:

LOAD Product,

Category

from table ;

LOAD Product,

concat(Category,',') as P_category

resident

Temp

Group By

Product;

try this in the front end

Product&','&P_category

[MarcoWedel]

Hi,

maybe one solution might be:

hope this helps

regards

Marco

[MarcoWedel]

another solution might be:

table1:
LOAD RecNo() as ID, *
INLINE [
    Product, Category
    product11, category1
    product12, category1
    product13, category1
    product21, category2
    product22, category2
    product31, category3
    product32, category3
    product33, category3
    product34, category3
];

tabProdCat:
CrossTable (Type, ProductCategory)
LOAD * Resident table1;

hope this helps

regards

Marco