Conditional Statement on 3 fields?

[DarleneP]

Hi all, 

I am creating a tree species database and 3 of the fields need to relate to each other.

The three fields will be: treecode, common_name, scientific_name- each with an assigned domain

How can I design this with the end goal being if any one of these fields are populated, the other two will auto-populate?

Thanks so much!

[AdrianWelsh]

I believe you can do with by using Attribute Rules in ArcGIS Pro.
https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/create-modify-and-delete-at...

You would use a Calculation Attribute Rule, looking for an insert or an update in one field, and then you would need to have some arcade script written out that is like a lookup table for what each field would mean to the other fields. So, it doesn't appear to be a straight forward process, but looks doable (and would be interesting to play with attribute rules as well!).

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/calculation-attribute-rules...

It looks like Esri has some documentation on writing the update/insert arcade expression here:
https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/attribute-rule-script-expre...

[AdrianWelsh]

one thing I forgot to mention, I believe you need at least a Standard level license to create and manage the attribute rules (now called a Professional license).

[wizgis]

Hi @DarleneP 

I believe you can use contingent values to achieve your objective. You can refer the following blog which highlights the use case : https://www.esri.com/arcgis-blog/products/arcgis-pro/data-management/contingent-values-in-arcgis-pro...