https://community.esri.com/t5/data-management-ideas/subtype-on-a-text-attribute/idi-p/925700 <P>Subtypes can be based on an integer attribute only.<BR />Please enable subtypes to be built on a text attribute.<BR /><BR />Example:<BR />I have a natural key for countries as a text string "US", "UK", "AT", ...<BR />I have to keep a surrogate integer key corresponding with the natural key in 1:1 relationship &nbsp;(1 ~ "US",&nbsp;&nbsp;2 ~ "UK",&nbsp;3 ~ "AT"...) and I have to ensure&nbsp;data integrity&nbsp;among these two attributes&nbsp;by rather complicated mechanism. This is due only to the need to create a subtype on the country...<BR /><BR />So, cucrrently, I have to make a complex solution for&nbsp;basic tasks...<BR /><BR />Please consider this functionality. This will simplyfy the application design in many cases a lot.&nbsp;</P><!-- content transformation source ID: 087300000008G4Z --> Thu, 25 Aug 2022 00:13:37 GMT RadekFujak 2022-08-25T00:13:37Z https://community.esri.com/t5/data-management-ideas/subtype-on-a-text-attribute/idi-p/925700 <P>Subtypes can be based on an integer attribute only.<BR />Please enable subtypes to be built on a text attribute.<BR /><BR />Example:<BR />I have a natural key for countries as a text string "US", "UK", "AT", ...<BR />I have to keep a surrogate integer key corresponding with the natural key in 1:1 relationship &nbsp;(1 ~ "US",&nbsp;&nbsp;2 ~ "UK",&nbsp;3 ~ "AT"...) and I have to ensure&nbsp;data integrity&nbsp;among these two attributes&nbsp;by rather complicated mechanism. This is due only to the need to create a subtype on the country...<BR /><BR />So, cucrrently, I have to make a complex solution for&nbsp;basic tasks...<BR /><BR />Please consider this functionality. This will simplyfy the application design in many cases a lot.&nbsp;</P><!-- content transformation source ID: 087300000008G4Z --> Thu, 25 Aug 2022 00:13:37 GMT https://community.esri.com/t5/data-management-ideas/subtype-on-a-text-attribute/idi-p/925700 RadekFujak 2022-08-25T00:13:37Z