Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to show two different fields of same table in an single listbox.
Thanks..
can you explain more?
Try like this
Add an expression like
Field1&'-'&Field2
etc
Do Concatenation in script &'-'&
Hi ,
The fields were
-> Product
-> Category
I need to show with in single list box as,
Product
Category
Thanks..
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
Hi,
maybe one solution might be:
hope this helps
regards
Marco
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