I have two fields in a geodatabase:
1) "LineType" - abbreviations of conduit types (CLC, CBC, RCP, etc..)
2) "Asset_Type" - the full wording of these abbreviations (Concrete Line Channel, Concrete Box Culvert, Reinforced Concrete Pipe, etc..)
Am I forgetting something simple, or is there no way (outside of programming / scripting) to set up an auto-populate of the "Asset_Type" field in SDE? I want to store this value, but don't want users to have to enter both fields for each new feature. I can programatically handle this pretty easily, but my issue is that data entry will come from multiple sources, such as importing GPS data, importing data from proprietary software, and regular data entry using ArcMap. Would rather do from the database side, not scripts.
Thanks for any help.