Not sure if this is the right forum, but it seemed to make sense to me. A bit of background; we are contemplating creating a database to handle/store historical transactions which will be maintained with an interface outside of ArcGIS.
I choose/desire to step outside the geodatabase for this information because there are limitations in the hierarchical design and relationships within the GDB, the interface for the required updates is comparatively cumbersome and time consuming, and having external (non ArcGIS interface) editing against the GDB leaves me feeling uneasy. For these reasons, it makes sense to me to have this information contained within a separate database.
I know you can make joins to specific tables within another database, but can you access the relational functionality/behavior contained within them through a join?
Does anyone work with a similar scenario like this?
