I am trying to write a script with two DB files

file 1 contains zipcodes and post office names

[color:brown][color:orange]file 2 contains a list of members and their zipcode .

I want to create a query using FM7 that totals the number of members in any given zipcode. This total would be a field called total members in file 1. Any suggestions on how I can do this?

Edited August 24, 200520 yr by Guest

It's not clear what you're after--are you hoping to store the number of members directly in the zipcode record, or do you just want a report telling you that info?

If the first, you might create an unstored calc field in the zip table with a formula like:

=Count[MembersOnZip::MemberID]

If the second,

Create a report layout based on a table occurrence for the Members. Insert a summary part (leading) for the zipcode overview, and include info about the Zipcode, based on the relationship to Zips (Location name, Zipcode). Insert a summary part (trailing) for the count of Members. You can include member-specific info if you want, or not; if not, you can reduce the Body to nothing.

I'm not looking at FM right now, so this is off the top of my head...

Try the Count() function:

Count ( file 2::MemberID )

I have attached the two files to assist in the analysis. I appreciate everyone's help. Ultimately this information will be used in a GIS application with a thematic map so I need a total for each zipcode record so I can color code the map. After I get the values I am saving the file as a DBF iv file

fm7.zip

Gees I can't believe it was that simple.

Thanks GUYS!