1 Reply Latest reply on Sep 22, 2013 6:40 AM by philmodjunk

    One or many?



      One or many?


           Hi there,

           I am a newbie and loving FMPro & FMGo. I have been using Harvest and Outright and also created a FM database to track actual activity details from my consulting and tutoring business. I want to get rid of Harvest and Outright and track everything myself. My question is should I make 2 databases (combining Harvest and Outright) and keep the separate one for activities or just make one?


        • 1. Re: One or many?

               What are "Harvest and Outright"? How do you use them?

               The question you are asking isn't as critical a question as you might think. Tables in one FileMaker Database File can be accessed from another FileMaker File so you can put all your tables in one file or several and the look and feel of your database system is much the same.

               What you DON'T want to do is set up a system where you have to store the same data in more than one part of your system. You don't, for example, want to set up a table of contact information in one part of your system and then have a different table of contacts in another.

               While there can be distinct advantages to using more then one file in certain cases, "newbies" are usually better off keeping all of their tables in one file as it is slightly simpler and easier to work with.

               Keep in mind that you can "grow" your solution, adding more tables, layouts, etc to your basic solution--gradually phasing out the other applications that you currently use as create a workable system in FileMaker with which to replace it.