Grouping Data

[chikanyc]

Hi,

I have a Composer DB and a Usage DB.

The Usage DB includes a Line Items Table which has fields to hold values for:

- Date of Usage

- Billing Quarter

- Composer

- Song Title

In my Composer DB, I would like to have a layout with a portal to display itemized usage via the Line Items table. I was able to do this without problem. I would like to take it a step further and show a summarized report on that same layout displaying the summaries of a Composer's usage by billing quarter.

So in the first portal, I have a relationship from Composer field (in Composer DB) to Composer field in (Line Items field)

Does anyone have recommendations on how to create a relationship for the second portal? Do I need to create a separate table? I would like to do this without creating a summary report..

Unsure.

Thanks for reading.

Edited July 30, 2009 by Guest