tmac Posted September 7, 2000 Share Posted September 7, 2000 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 Link to comment Share on other sites More sharing options...
WBlanchard Posted September 7, 2000 Share Posted September 7, 2000 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8637 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now