How do I Include Relational Data in a Report?

[Bending Unit 22]

I would like to create a report that will show related data. For example, I have a database (DB) that tracks websites. The DB has 4 tables; Website, Owners, FQDNs and Notes. I want my report to look something like this;

********************

WebSite - MyWebSite

Owners - John Doe, Jane Doe, Robert Doe

FQDN - www.mywebsite.edu, mywebsite.edu

Notes -

10/05/06 Created a new page.

10/06/06 Deleted page.

10/15/06 Added graphic to main page .

11/01/06 Attended conference to discuss future changes to the look and logic of website.

********************

What would be the standard way for extracting the data from my 4 tables to get this type of report?

Edited November 6, 2006 by Guest

[DukeS]

You can report only one set of related records in report ( body part ). In your case this are changes that were made on website.

For website name and owners, you can use text field and display them in header part of the report.

Base table for report must be related table.