1 Reply Latest reply on Mar 26, 2010 7:20 AM by Digiguy

    Contacts database to invoices

    Somerby

      Title

      Contacts database to invoices

      Post

      If I have a contacts database and I want to produce invoices, do I modify the contacts database adding in product tables etc, or do I create a new database and import the existing contact records? If I import, won't I have the same info in two places? But if I modify the contacts database, then won't it stop being a simple contacts database?

       

      You can probably tell I'm a novice with relational databases. I'm using FM10 on Mac OSX 10.6.2

       

       

      Somerby

        • 1. Re: Contacts database to invoices
          Digiguy

          It is easier to do it all in one database and have access to all the tables, but there may be reasons one would want to use 2 different databases, personally, I prefer it that way. Imagine your database goes down, and ALL information is lost, or you want to use the contact manager database for another database, or for security reasons want to lock down the invoice one, or the contact one (or preferably both) for privacy reasons. As for an education on how to do it, that is best left to the experts to teach you, and I am sure you are like the rest of us, trial and error, and by example are good teachers. Download or use some template databases, of both types and see how you like modifying them and working with them, only once you get your purpose straight will you be able to get the direction down as well of how to plan it.

          Hope that helps,

           

          kirk