Creating report with prorated numbers

May 31, 200520 yr

I have a FMP7 database of voting data that now contains these tables and fields:

tblVoteData: County, Location, Candidate, Race, Votes

tblRegistrationData: County, Location, Precinct, RegisteredVoters

tblVoteDate is the raw election results with Votes aggregated by reporting Location. Each Location with contain one or more precincts with a certain number of registered voters (per precinct), and tblRegistrationData has that information.

Ideally, the political gurus would like a report of votes for each candidate by precinct, but the data is not reported that way. But they will accept a report with votes for each candidate prorated to the various precincts within each location based on the number of registered voters within the respective precincts for that location.

How would I approach this proration? I think I can relate the tables based on County and Location.

Any suggestions would be appreciated. I hope this is clear.

James McAlister