Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report with more then one child table

Status
Not open for further replies.

OldSmelly

Programmer
Nov 22, 2001
70
NL
Hello,

I want to print a report with one parent table and 4 child tables ... Does anyone know how to do this ?
 
Hi

Set the relationship as usual with one parent and one child table, but in this case set the relationship to all the child tables. Make the report as usual and refer the fields with alias names of various tables properly.

If you are thinking of having multiple report bands..
How to print Multiple Detail bands in a Report
faq184-1253

:)



____________________________________________
ramani - (Subramanian.G) :)
 
Thanks I didn't realise there was a faq on this topic....

** Need to update my search skills ** :-(
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top