Hi again, I have another question coming from EnterpriseObjects land: I have a situation where two different applications each have their own application specific set of tables in their own schemas and share a third set of tables in another schema. Each application has tables with relationships to the shared tables, but the applications are not related to each other.
In EnterpriseObjects it's possible to create separate models of the shared tables and each application's private tables so that one copy of the model of the shared tables can be shared between the applications. Can something similar be done in Cayenne? It appears that multiple projects can be imported into a runtime easily enough, but I'm missing how I can create relationships between objects in two different projects. The alternatives I see are to either duplication the model of the shared tables in each application's project or including all the models in one project, both of which are less than ideal. Maybe I've missed something? Thanks! -- Paul