>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.