One Comapny - Three Divisons - Multiple databases?
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!
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.
- what is the best way to setup the database(s)?
- should we make a database for each diviosn and then have relationshipds connecting them?
- How big can a database be?
Any advice in the initial building of teh database(s) would be greatly appreciated.....