I have a db with a script that opens a new layout in preview mode that is a letter home to parents containing information from a student record.

If I enter information into a new record, then go to letter preview all records are present.

How can I set up a script so that only the letter associated with the particular record is generated.

Student information comes from another db by SetField, Perform External script, etc.

Also, can anyone direct me to a training program, book with this info in it...Quickstart and VTC don't really help me here (even if www.fentonjones.com did...thanks Fenton)

TIA

Stephen K

The usual solution to showing only one record in preview is to isolate that record in a one record found set. The easiest sequence of script steps to do this is:

Show All Records

Omit Record

Show Omitted

You can also use the Go to Related Record (show) script step, as appropriate.

IMHO, the best FileMaker 7 book is Special Edition Using FileMaker Pro 7 by Steve Lane, et al.

-bd

Thanks B