I work in electrical utilities and we have stacks of paper records that need to be updated into an existing SDE feature class attribute table. My problem is that someone in the city's GIS office would like me to create a simple interface where anyone with access can search a for a pole number and edit records in that row of the attribute table with a menu-like interface. He/she's reasoning is that employees with little GIS experience won't make mistakes with the data. Is it possible to construct something like this that would provide any benefits over starting an editing session and just keying values into the attribute table?
I thought about it some more and even just ArcGIS Online would be a potential solution. I know this will work with SDE datasets because I created a Collector application that directly edits features stored in our SQL Server database. I can access them through my ArcGIS Online account with the Collector App on my iPhone (can use Android too). This also requires ArcGIS Server (service should be published using "Feature Access") so be aware of that. Here are some good links.
Collector Documentation http://doc.arcgis.com/en/collector/
You could also create a map this way with ArcGIS Server and just edit the webmap online (another option) but it is just as easy to set it up following the tutorial.