Using fConcatChild to cantonate 1:m relationship data

[Eric]

I using the fConcatChild code to consolidate informaiton from 1 table to
another.

this function is taking all the information available form the many table
and replicating in for each record count.

I believe that I need to place something in with statement the to break up
the many information for each record

E.G. PropID - 1 to tblMulit - Plain; Brown; Silver
PropID - 2 to tblMulit - Ruff; Brown; Granite

and not show it as Plain, Brown, Silver, Ruff, Granite

Any suggestions?

Thanks.

 

[Duane Hookom]

We can't help without you at least providing the syntax you used.

However, I generally suggest using the generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. There is
some sample usage in the download.