We would like to contact our volunteers based on their geographic location. We settled on zip codes as a reasonable proxy for location, and now have a table with volunteer contact information and zip code. I have a shapefile of the zip codes in our state, and have related this our volunteer table as it will be a many-to-one relationship. Now I can click between the two tables, but I can't figure out how to get the spatial information and the contact information into one place - ideally a shapefile - that I can use to select volunteers based on location (by selecting all volunteers within 30 miles of an event, for instance). I see in "transfer geometry of a feature class into a table" (Transfer geometry of a feature class into a table) that there is a way to transfer point data into the table, but not how to do that.
Is there a way to get the spatial information from a shapefile to attach to a table that contains many records matching individual polygons? The ideal outcome would be a point shapefile with all the volunteers appearing as overlaid points at the center of their zip code (or even better, overlaid zip code polygons with the volunteer's information associated with an individual polygon). If there's something less awkward than a relate, I'm happy to change methods.