>THINGS
>thingnum description
>1 something
>2 something else
>3 yet another thing
>DOCS
>docnum docdescript
>1 "important doc"
>2 "more important"
>3 "whatever"
>THINGDOCS
>thingkey dockey
>1 1
>1 2
>2 3
>3 2
>3 3

Also... you could do a simple query like...

select a.thingkey,b.docdescript from thingdocs as a, docs as b where a.dockey=b.docnum

This should give you a cursor like...

1          important doc
1          more important
2          whatever
3          more important
3          whatever

From there you can write your report so it groups on Think Key... in the footer of the group you can do the append of the strings.

BOb