>>If you have a parent table with many child tables (say 6) how do you print the parent record
>>first then all the records related to the parent table in the first child table, then the next child
>>table etc. Since the Report Designer does not support subreports how can this be done?
>>
>>Any suggestions will be greatly appreciated
>
>build a cursor using sql statement containing parent w/ all children. run the report from that.
OR...and this is kind of a pain in the tail, but it works, and since it wasn't my idea, I like to think it's a little ingenious....
for each child, write a function which accepts the key as a parameter and returns the child result set as a preformatted text block. I've done it. You'll need to use characters for total lines and header lines...but it works for me..
HTH
Matt
Matt McDonnell
...building a better mousetrap with moldy cheese...