Script merging related fields

[Chuck J]

I'm using FileMaker 4 on Windows

You don't want to hear what I have tried, so here is the problem. I have two related databases Courses and Students. From the Courses database I want to print a letter from a found set of students in the Students database.

Record_number is the key field.

I prepare the letter in the Courses Database with Record_number, First_name and Last_name related fields from Students Database.

I find the students that should receive the letter and create a script:

Freeze Window

Perform Find Request 1

Restore find request Mail List Yes

Loop

Copy Record_Number

Select entire contents

Open Filename: "Courses.FP3"

Paste Courses::Record_Number

Perform Script External: Courses.FP3

Sub-scripts Print_Announcement

Go to Record/Request/Page

Next

Exit after last

End Loop

The Print_Announcement external script I have in Courses is:

Go to Layout Course_Announcement

Print

No dialog

I need a script in Courses or Students that will print a students first and last names in the letter from the found set, go to the next students name, print the letter and continue through the found set in the Students database.

I'm perplexed once again but I'll keep trying, I have just run out of ideas.

[Ender]

It seems easier to print the letter from the Student file. Then you would just need to set a global in Student with the current Course Number, and use a relationship from Student::Course Number to Course::Record Number to see any Course info on that letter. Then when you can print the found set in one Print[] step.

[Chuck J]

The reason I didn't want to print from the Students database is the letter would be part of a students record. I would prefer the letter be part of the Course database record.

Any help on this one?

Edited November 26, 2005 by Guest