I have a featureclass of cities and a separate table of city administrators (multiple administrators for each city) and related contact info.
What I need to do is consolidate all city administrator info into the attribute table of the city featureclass. I'd like to add and populate fields for contact1, contactemail1, contact2, contactemail2, etc etc
A join, obviously, dumps all but the first record.
The relate shows me all the info i need, but I need to somehow copy all that info into a single row in the original featureclass, rather than clicking on each city to see the related table.