In an earlier thread, ( IIF function in Dynamic Value table ) Jennifer Stone discusses a rather long, nested IIF statement she was wrestling with to update a numeric column based on a entered city name. She has since gone on to win that match!
I have a similar but slightly different situation: rather than update a field based on another field's value, I need to check the value of a field to see if the entered value is valid with respect to the entered (earlier in the workflow) value of another field.
Lets say I have 3 city codes, A, B, & C. Each of these cities have a list of allowable zip code values associated with them:
City Zip(s)
A 84120, 84121, 84123
B 84020
C 84124, 84125
The city code is entered before the zip code.
The idea is to have the editor enter the values as (s)he goes along, but, if for example, city A is entered and 84020 is entered as the zip code, we get an error.
Can Attribute Assistant be used to check for errors in data entry? Or is this more of a task for the Data Reviewer extension?
Michael Miller
