I've been playing around with 'Maintaining Attribute Integrity' functions found here:
I see how I can set domains and subtypes to control the values in the attribute table to maintain quality and how to validate features and relationships using the tools ArcGIS provides.
I don't know if I am missing something, but I have a situation where values in one field in an attribute table, depend on the value in another field in the same attribute table.
Let's have 3 fields (CITY, PROVINCE, COUNTRY)
Let's say I set a domain on the CITY field to populate a list of all the cities in the world. I want to be able to validate that the PROVINCE and COUNTRY fields are correct. So, for example, if I enter 'Toronto' in the CITY field, I want to validate that the PROVINCE field is 'Ontario' and the COUNTRY field is 'Canada'
I'm not sure how to set up the domains or subtypes to do this. I want to be able to run the validate functionality found here:
To throw an invalid error if these conditions aren't met. Can anyone suggest how I can accomplish this?
I can do this through python, but the validation in ArcGIS does a lot of things I was going to script, so I'm hoping it will do this for me too.