Concatenate child field for each record

[jonohara]

I have a query which lists products. When a product has several options (i.e a pillow may either be feather or polyester) it is listed several times in the query results.

I need to either add a field to the exisiting or create a new query which groups the product and shows all the options concatenated in one field. i.e.

from:
prodid prodname features
1 pillow1 feather
1 pillow1 polyester

to:
prodid prodname features
1 pillow1 feather or polyester

Thanks

 

[lespaul]

See Thread700-866768

Leslie