Many tables and relation sql = many group detailband

Hi;
Please I have a problem:
---- 1 TABLE (Headerband)                       ok this!
* (group one)                                        ok this!
-----2 TABLE (many records) <detailband>  ok this!
* (group two)                                        ok this!
my problem is this:
-----3 TABLE (many records) <detailband>  not possible this!
..... and more... more.........<detailband>  not possible this!

ok, solution this, where?.
thanks everyone.

In article <tsirkF8zHHA.320@news-server>, menendezconsulting@virgilio.it 
says...
> Hi;
> Please I have a problem:
> ---- 1 TABLE (Headerband)                       ok this!
> * (group one)                                        ok this!
> -----2 TABLE (many records) <detailband>  ok this!
> * (group two)                                        ok this!
> my problem is this:
> -----3 TABLE (many records) <detailband>  not possible this!
> ..... and more... more.........<detailband>  not possible this!
> 
> ok, solution this, where?.
> thanks everyone.


G.Menèndez,

I have not done such a deep linking in a while, but it can be done. 
However, there are people here who have run into problems when things 
get more than one or two levels deep. The general consensus seems to be 
it is better to work from a flat table (create a table specifically for 
this report and fill it before calling the report) -OR- base the report 
on a single query where there is a complex SQL statement linking all the 
tables. I generally do the latter. Here is an example of what I would 
assign to a QUERY.sql:

select a.field1, a.field3, b.field1, b.field5, c.field4, d.field9
 from yourTableA a
 join yourTableB b on( a.someID = b.someID )
 join yourTableC c on( b.someOtherID = c.someOtherID )
 join yourTableD d on( c.someOtherNiceID = d.someOtherNiceID )
 order by a.field1, b.field1, c.field4

You can expand on this by using a WHERE clause.

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.