yes, I'm doing that now. just be aware that cross db joins are a b*tch. if there are to many relations to join across you will quickly hit limitations with IN clauses (which will be your best friend). unless someone else has come up with something more clever than what I'm doing
-Mike On Dec 20, 2012, at 6:45 PM, Miguel Torres <w...@toracom.net<mailto:w...@toracom.net>> wrote: Hi list, We are developing an ERP application. We want to use the following approach: One database to storage users, access control rules, application configuration and an enterprises catalog. For each enterprise we want to set up a different database. For example: One ERP controlling information of two enterprises would need three databases: * ApplicationDatabase * EnterpriseOneDatabase * EnterpriseTwoDatabase We are doing this because we believe this is more efficient in the long term with clients that have more than one enterprise. We have two Data base Models in the application * ErpApplicatioEOModel * ErpEnterpriseEOModel The main page is a Login form where the user selects the Enterprise she wants to work with. After the user logins successfully we want to set the database connection information in the ErpEnterpriseEOModel. Is that possible? Thanks in advanced. Saludos, Miguel Torres. _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com<mailto:Webobjects-dev@lists.apple.com>) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/mgargano%40me.com This email sent to mgarg...@me.com<mailto:mgarg...@me.com>
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com