Printing 2 different layouts together

[PrincessJo]

Hi,

This is my first post, and I'm not sure how to explain this, but I'll try :

If you have ANY suggestions I'm listening :

I have my main layout with a subsummary based on person. This person may have many records relating to other things. I have a second layout, which is the 'back page' of the rest. Depending on how many records a person has, they might have 1, or they might have 6 pages in the first layout.

When first thinking about this, I thought it should be an easy thing to do to make a script with a loop, printing the first record on the first layout, printing the first record on the second layout, and then going to the second record. But this doesn't work because once you're in Preview mode, printing 'record you're currently browsing' only prints the one page.

It needs to be printed it order (it's far to big a task to print out all of one layout then all of another then reorder them).

It also needs to keep it's 'find' and it's sort. ie, when someone does their find to print what they want, it should print those records. It can (well, it has to) do another sort by the subsummary field, but that's ok.

So, any ideas?

Thanks!

Jo

[BobWeaver]

You can probably do it all on your first layout. Create a trailing sub-summary when sorted by person. Make it a full page long. Then, put all the fields in it that you had in your second layout. Select the "page break before each occurence" option for this sub-summary part.

[PrincessJo]

Hi,

I have to say thanks to Bob, that was a brilliant idea, and *almost* worked. I was really excited about it for quite a while. But. Always a but

So now a futher question.

The second layout (for the back page) is actually another record.

Each record is a summary of a course a person did, and then they have another record that is the 'overall' type thing, which is the back page. So the overall record, is, as far as the Database is concerned, just another course.

The way I was thinking originally was to somehow identify the summary record, print all records for a person until the summary is reached, still go to the next record, change layouts, print that one, then go to the normal layout and next record until the next summary is reached.

Is there a way I can work with that?

From what been suggested already, I can see a workaround, but it means restructuring the database that is almost done.

Any suggestions welcome, and thanks for the inspiration!

Jo

[BobWeaver]

Well, unfortunately it's generally a very bad idea to use records in the same file for more than one purpose. (It's also bad idea to use a field for more than one purpose.) You likely should have your summary records in a separate file related by the person. That would make it very easy to print the report that your want, because the summary info from the related file would easily go into a sub-summary part.