I wasn't quite sure where to put this so just hear me out first...I'm ok with general relation database theory but i have real problems when it comes to reporting certain information...

Righto Lets say i have two tables:

Table 1

- ID 1 (Unique)

- Date Field 1

Table 2

- ID 2

- Date Field 2

The relationship is structured as such:

ID 1 = ID 2

& Date Field 1 <= Date Field 2

So basically i want to filter out all the records that don't meet the criteria of the relation ship... and present a report laid out something as such:

ID 1 (Record 1)

ID 2 Date Field 2

ID 2 Date Field 2

ID 1 (Record 2)

ID 2 Date Field 2

Finally to the question... what goes where? what goes into the body, the subsummary part, which TO should the report be set to? etc etc...

Im sorry if this is a bit unclear but... sigh, any attempts at help would be appreciated

Cheers, Genx

... I'm going to assume due to the lack of responses that it is most likely not possible to do it this way so i am going to resign to using a simple calculation field that sets to yes if Date Field 2 is >= Date Field 1...

Thanks for at least having a look...

Genx

Try the attachment on for size.

SampleReport.zip

Your example is really unspecific, which makes comment tough. Let me try, though:

When I am trying to build a complicated report, I have found that you have to build the report from the perspective of the finest granular data. So if I am making a report that lists Services by Client, I build the report on the Services table, with data from Clients brought in by relationships. In your example, use Table 2 as the basis of the report. Create a subsummary when sorted by T1::ID 1 and put everything related to the T1 record there. Then put your T2 data in the body element.

HTH.

David

Thanks Queue, even though i know my example wasn't that great / specific, that filtering script was exactly what i was looking for

Cheers for all help, Genx