I have a report that does exactly this in the opposite order. I sort of cheated however, by loading up arrays 5 elements long for the small database. Then I just displayed those arrays on the form. This may not work for you, because it will leave a little space empty between the portion of the database. I put my array fields in the report summary, but yours would probably go in the report header.
>I want to create a report with two different and unrelated tables.
>The first table wiil show a max of five records The second will show a max of about 50 records.
>
>I have created two seperate reports one for each table and each is fine.
>
>I want to be able to be able to run the shorter one then have the longer one print right after that continuing on the same page. Both tables have only one matching field and that field contains the same valve for all records.
>
>Can this be done.
>
>If not in foxpro. will cystal Reports do it.
>
>Any help would be greatly appreciated.
>
>Thanks Keith Hartman