Hello,
I am running the Data Reviewer domain check on an address point feature class. In the feature class, numerous fields use domains but may also allow Null values. Examples: unit type (which is only used for specific address types); HALF (which is old-style 1/2 addresses), among others. IF there is a value for the field, it must come from the domain, but it can be empty as well. When I run the check, I do NOT have the "Search for Null Values" option checked.
Data Reviewer keeps flagging two fields as having "invalid domain values", while it seems perfectly happy with blanks in other fields. When I look at the table, most of our optional fields are "blank" (I.E. no NULL or <NULL> there, just empty white space in the table). However, it appears that at least for some fields, Data Reviewer wants NULL instead of a blank. I am trying to figure out how to get Data Reviewer to stop caring about NULL versus blank, or if that is not possible, how do I get the database set up to automatically fill in NULL if there is no data (at least on new records).
Any advice is appreciated, I'm starting to get a permanent indent on my forehead from banging it against my desk!