Help with a Report Layout

[Lyle Phillips]

I am trying to create a report that has the fields from a record from one database and then selected fields from another database in the body. Actually in the header, I am describing a situation and in the body the individuals from another database to document their responses to the situation that is listed in the header. The two files are not related. Bottom line, I want to document the situation with a description, date, etc. and then print a listing of the situation and a list of the individuals with phone numbers, etc. so I can call them apprise them of the situation. So far I haven't figured out how to do this. Anyone have any ideas?

[Fenton]

It sounds as if you want to temporarily show data from one file in the Header of another file. You can either use some kind of funky copy/paste into a global field (which, BTW, are only enterable in a FileMaker 6 Header in Form view), or better, set a global field in file2 to the ID of file1's record.

Then create a relationship from the global in file2 to the ID field in file1. That will allow you to show data from whatever record in file1 in the Header of file2. Clear the global when you're done (especially before closing the file).

[Lyle Phillips]

Option #2 worked perfectly. This is exactly what I needed. Thanks so much for your insight and help. Most of all for taking the time.