Mailing List help

[gcottle]

I am working with a single-file contact list that we use to send mailings out to recipients. I would like to have two features that I am unsure how to implement.

First, on the data entry page I want to have a running total that shows records for each city, displayed either by city name (mailAddressCity) or by zip code (mailAddressZip).

Second, I need to establish a related file that shows who was sent what mailings (i.e., initial letter, version 1 sent to cities x, y, z, and initial letter with flyer sent to cities d, g, h. The letters currently are forms within the contact file. Is this the best architecture, or do I need to create a seperate file that has just the letters? Also, when I do a find and then print, do I use a script to pull the list of found records into a related field or what? Each record has a unique ID based on the one in the sample files.

Thanks for any help.