Hi Billy!
There is only way to do this hardest thing.
1. Make cursor Tmp that contains all field from Table A,B,C
2. Scan table A and count records in tables B and C
You'll have table looks like:
RecfromA CntFromB cntFromC
1 2 1
2 3 2
etc
3. Scan table A again and add in cursor Tmp the maximum amount of record
from table mentioned in step 2 for each record in A.
4. Fill cursor with all necessary data from all tables (A,B,C)
5. Make report one-to-many style.
HTH
Have a happy day
Vladimir Shevchenko
P.S. Or try another reporting engine ;)
> >to printer. You can do it with method CaptureScreen of Sysinfo class
> >that available on UT
> Thanks for the advice. I decide to make a report but now I have another
> problem. I have 3 tables (A,B,C for example). A has one-to-many
> relationships to both B and C. I know how to do a report on one
one-to-many
> relationship but how can I do on two?
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer