Database Setup:

1 Master

2 Slave

Example of Problem:

Master has 10 records...

Slave has 43 records...

They are related by text field called "Initials". The Slave may have 4 records with the same "Initials" value with different info in it else where.

QUESTION:

I would like to print a numbering scheme on a sheet (Per RECORD) showing "sheet 1 of 4", then "Sheet 2 of 4" etc. Once that RECORD is finished printing, it starts over with the next one ("sheet 1 of 5", etc.).

I'm not sure how to approach that? any suggestions?

Thanks!

[ April 10, 2002, 03:03 PM: Message edited by: Addam ]

If I understand what you are asking, you want to print one report for each record in the master file. This report is to consist of one sheet for each record in the related ("slave") file.

This can be done with a looping script in the master file:

Go to Record/Request/Page (first)

loop

Go to Related Record(slave by initial, show only related records)

Perform Script(External, Print One Set)

Go to Record/Request/Page(next, exit after last)

End Loop

In the related "slave" file, define a global number field "gPageNum". Place "## of <<gPageNum>>" at the bottom of each page of the report, and use the script:

Go to Layout(print layout)

Page Setup (restore)

Enter Preview Mode

Go to Record/Request/Page (last)

Set Field (gPageNum, Status(CurrentPageNumber))

Print ()

Enter Browse Mode

-bd