Report based on master-child relationship

[iztok]

Hi,

I'm new to FM and haven't been able to find an answer to what I assume is a trivial task. Any help is greately appreciated.

I'm trying to create a report based on two (three) tables e.g.

Table 1: Contract

contractId

clientName

contractDate

Table 2: Performer

performerId

firstName

lastName

Table 3: ContractPerformer

contractId

performerId

Based on this table structure I'm able to assign a number of performers to each contract. I achieve this using a portal to the Performer table while entering data into Contracts table.

I can create a report using the report wizard that generates a list of all contracts grouped by a date, however I can't figure out how to also display performes assigned to each contract.

Something like:

Date 1

contract1, clientName1

performer1.1

performer1.2

performer1.3

..

contract2, clientName2

performer2.1

performer2.2

performer2.3

Date 2

contract1, clientName1

performer1.1

performer1.2

performer1.3

..

contract2, clientName2

performer2.1

performer2.2

performer2.3

Thanks, Iztok

[RalphL]

Your report should be done in Table 3: ContractPerformer. You use related fields from the other 2 tables to suppy the data. You are on the right track.

[iztok]

Ralph,

That worked great. However, there is a peculiar side-effect.

Report is just as I wanted it, organized by date, then contract, followed by the list of performers assigned to that contract.

The part that I don't understand is that the report ends with an extra entry at the very end. This extra entry has a blank date, blank contract, followed by a long list (several pages) of blank performer records interspersed with some real performers.

Any hints? Thanks, Iztok

[RalphL]

It sounds like you have a bunch of empty records. Search for records in Table 3: ContractPerformer that have empty contractId or performerId.