I'm currently creating an ArcSDE DB on an SQL Server. It is designed to complete species survey, with information from the field.
In order to help themselves, they asked me to implement a particular yet logical behavior: in a first field Order, they want a list of related taxa. In a second field, a list of Genera (Genus) related to their Order choice. In a third field Species the list related to their Genus choice.
Basically, it is the subtype/domain behavior, but here, the field Genus should be a subtype and a domain at the same time and it's not possible.
So, I thought about implementing this behavior in SQL Server but is it possible? Moreover, will this behavior work directly in ArcMap when working in a editing session on the DB?
Other ideas? Thanks, Merlin