Value List From Multiple Related Files

[tmac]

A local organization runs 4 fundraisers each year. They have 4 databases that maintain records for each. What they want to do is create a master report that lists everyone who's worked one or more of the fundraisers and their total collections for each event in which they participated. Some individuals work all 4 and others just 1. How do we get all the names into one field with duplicates removed. I can display names from any one of the 4 easily but can't get a combined list. A calc field combining participant lists from the 4 databases fails with a beep and message saying "this field can't be found."

The organization would like to have their information displayed similar to...

Participant

[WBlanchard]

I would think you would need one more file. A participant file. In this file you would have all participants and create links back to each of the fundraiser files. With these links [relationships] you could associate the $Collected FR[n] field in each file back to its participant and then display that data.

Hope this helps