Have changed the city field for buyers in the database to be longer and deleted the state and zip fields.  Have also modified testconnectand populate and console to populate the database and read it.  What's left to do now is to change the buyer entry form to remove the separate fields for state and zip.
Have made all changes to BuyerEntryForm to adapt to a single field for city, state, and zip code.  I've done fairly extensive testing, and all seems to work.