Reports creation problem

[Xenocide]

Hi

I'm trying to create a reports that would when finished show sometihng like that

04-000000-01 Some information
15-000001-01 Some information
15-000001-02 Some information
15-000001-03 Some information
04-000000-02 Some information
15-000002-01 Some information
04-000000-03 Some information
and so on

All those stuff are in the same table and the 15 one are linked to the 04 by a rows in that table I named master (15-000001-01 master would be 04-000000-01 for example)

The problem is that I don't know how to create a report that would show like that. I managed in some way to show the 15 under a 04 but it show the 15 based on the first 04 that will appear on the report no matter which 04 it is under

Can someone help me out with this one please?

 

[The_Doc_Man]

I'm a bit confused.

Are you saying that some records in your table are related to other records in the same table, and that the definition of this relation is in some sort of separate cross-referencing table?

Further, you want to group according to this separately defined relationship?

Can it ever occur that some records have no entries in the separately defined relationship?

I think the answer to your question will be to somehow build a query based on the table that defines your relationships, but it might have to be an OUTER JOIN case if you can sometimes have no related records to whatever you call your "parent" record.

An alternative is to build an extra field or two in the records and write some type of query that selectively updates these fields according to some pre-defined sorting order. Then sort the table by the sorting fields but don't actually display the fields. You must treat the sorting fields as temporary data - i.e. you cannot trust it from one report cycle to the next. You must ALWAYS regenerate the numbers each time.

 

[Xenocide]

I,ve tried a couple of things with what you said and I think I came up with something that seem to work

Thanks