Report with multiple clients - Stuck

[Bonez]

Hi,

I have a project database that handles quotes for construction tenders. The way I need it to run is that we have one project(parent table) with multiple clients(child table) that we send it to.

The problem I have is with the layout for the report where I want to replicate the report once for each of the clients showing their contact details but the remainder of the report (with sections, section items, and item components) stays the same.

My tables are similar to this

Project (Project No, Project Title)

|

-Clients to send it to (Client Name,email etc)

|

-Sections (Section Name)

        |

        -Section Items (Item Name, Qty)

                      |

                      -Item Components (Component ID, Description, qty, cost)

When I was doing a separate project for each client I had no problems obviously but now I am stuck!

Any help would be appreciated

Edited November 20, 2009 by Guest

[bcooney]

How about gathering the ClientIDs in a $var and then looping, setting a global field gClientID to each of the values in the $var. . The client fields on the report would use a relationship that uses the gClientID field to Clients.

You'll use $counter = ValueCount ($var)

Set Field (gClientID, GetValue ( $var, $counter)