AnsweredAssumed Answered

One Comapny - Three Divisons - Multiple databases?

Question asked by AJ135 on Dec 12, 2012
Latest reply on Dec 22, 2012 by philmodjunk

Title

One Comapny - Three Divisons - Multiple databases?

Post

     Hi

     I am a new FM user, have wanted to do this for a long time, but felt it was too big a job....my thinking has changed and i am ready for the plunge!

      

     BACKGROUND

     We are a small company divided into three seperate divison (each selling a different product or Service). We have 11 Associates, each one of them can interact with either of the divisons at any time. Many of our Clients will be connected to either 1, 2 or all 3 divisons. Two of the divisions have inventory with pictures etc that we would like to include in our database. The third divison is basically a service orietated divison.

     QUESTIONS

         
  1.           what is the best way to setup the database(s)?
  2.      
  3.           should we make a database for each diviosn and then have relationshipds connecting them?
  4.      
  5.           How big can a database be?

     Any advice in the initial building of teh database(s) would be greatly appreciated.....

     Thanks

     Andrew

      

Outcomes