Hi Everyone,

You can just respond to the question in the thread title. For a bit of an explanation (that might prompt a workaround), here is what the client wants.

Law firm...wants to print detail of a single client file. Here are the tables and their relationships:

MainTable: Plaintiff, heading detail (name, date of birth etc; used to print in header area)

--> ChildTable1: contacts on this file (multiple, related to main by File_ID)

--> ChildTable2: annuities purchased for plaintiff; multiple; related to MainTable by File_ID

-----> GrandChildTable1: who purchased each annuity (multiple litigants may have contributed to purchasing the annuity); related to ChildTable2 by Annuity_ID

Results so far: I can get the info to print but the GrandChildren print *after* all of the ChildTable2 records whereas I would like the info to "interleave" in between each annuity e.g. (showing just the annuities):

Annuity 1: Sun Life of Canada, Total Premium: $10,000.00
---> Crash Dummies Casualty Co, Contributed: $5,000.00
---> Total Wrecks Insurance Co., Contributed: $5,000.00

Annuity2: The Manufacturers Insurance Co., Total Premium: xxx.xx
etc.

It could be that I am not putting in the right "target alias" for that expression (I have tried several). I am currently putting in "GrandChildTable1".

Thanks for any help.

Albert Gostick