2 Replies Latest reply on Aug 10, 2010 7:30 AM by davidanders

    FMP Capabilities question(s)

    gonico

      Title

      FMP Capabilities question(s)

      Post

      Hey guys,

      As you know, purchasing FMP 11 is quite expensive, and before I make the plunge, and take the time to learn the product (i have no prior knowledge of databases), I wanted to see if FMP will accomplish what Im hoping it can.

      In my business, I use the following: Invoice, before and after pictures, exel / word files, pdf files.  

      Is there a way, that I can link all of these together? I would like to see an invoice, and have a link to the pictures, report file (word / excel file), and the pdf file.  Every project I work on has these 4-5 items.  Is there an elegant way of keeping all of this together in FMP?  

      I currently just have a folder with subfolders (invoice, pictures, reports, pdf files).  However I would like a neat way of doing this in FCP and even being able to search by invoice number, customer name, project name, etc etc.

      If this is indeed possible, I'll download the trial, buy a few books and teach myself how to do these things.  

      Thanks a bunch!

        • 1. Re: FMP Capabilities question(s)
          sunmoonstar.13

          >  I would like to see an invoice, and have a link to the pictures, report file (word / excel file), and the pdf file.  

          With FMP, you may soon discover that you can do away with the Word and Excel files. The text/numerical data in these files could be stored in FMP tables and fields, and you can generate, format and print reports of this data whenever you need, without having to save them as hard files all the time. FMP can save such reports as PDFs too, if you want.

          Images can be kept in your folders and "referenced" from within FMP or they can be imported directly into a "container" field in FMP. In either case, you'll still "see" the image within FMP. If you have lots of images (and it sounds like you do), "store only a reference" is the recommended method for working with images, otherwise the file size of your database can quickly become huge.

          > search by invoice number, customer name, project name, etc etc.

          Easily done in FMP.

           

          I reckon download the trial version and go have fun!

          Nick

           

          • 2. Re: FMP Capabilities question(s)
            davidanders

            When you download the demo you will be able to create databases from the templates included, some are good, some adequate.

            There are Open Free databases available that are very good, very specific and somewhat more complex to customize

            General Database

            http://fmstartingpoint.com

            Donations Database

            http://filemakerdonations.com/

            http://www.data4life.net/

            White Paper for Novice FMP Users

            http://www.foundationdbs.com/downloads.html