>
>create cursor stylelist (style c(10),synonyms m)
>select styles
>scan
> select synonyms
> lcSynonym = ""
> scan while fk = styles.pk
> lcSynonyms = m.lcSynonyms + iif(empty(m.lcSynonyms),"",",") + synonyms.synonym
> endscan
> if _Tally > 0
> lcSynonyms = "("+m.lcSynonyms+")"
> endif
> select styles
> insert into stylelist values (styles.style,m.lcSynonyms)
>endscan
>select stylelist
>browse
>
I forgot to mention that the result as to be also with the OleDb provider. Thus, one big SQL to achieve all that.