2 Replies Latest reply on Jul 30, 2010 12:31 AM by fluffyone

    pdf's and images in a database

    fluffyone

      Title

      pdf's and images in a database

      Post

      Hi Group

      I want to start a database that will have images or pdf's attached to records, but I don't want to have a long term problem where i fill up the database and make it really slow. What is the best way to go about this?
      is there a way of keeping attached files to a minimum size, are they linked or embedded?
      can I point to a directory that will show any file name that is the same number as the record number so that it only shows related files?

      The intention is to have a reference picture or sketch attached to a record, I would like it so that on the form it is set to a reasonable size for viewing but when clicked or mouse over it will be shown bigger, possibly with zoom and scroll features.

      Also when in a table view that shows many records I would like a field indicating that there is a picture attached to the record line and then when the mouse it over or it is click a window will op up showing the picture. Is this possible?

       

      I am just starting to play with this, but I intend on using information attached to records a lot in the future.

      Regards
      Fluffy

        • 1. Re: pdf's and images in a database
          philmodjunk

          You can insert files such as PDF's or Pictures into a container field. One of your options when inserting is "store by reference" which inserts the file path into the container field instead of copying the image.

          "can I point to a directory that will show any file name that is the same number as the record number so that it only shows related files?"
          Not with just filemaker, but there are file manipulation plug ins that can do this. If you have a windows system, check out Moo Plug as it has such features and is a free download.

          "Also when in a table view that shows many records I would like a field indicating that there is a picture attached to the record line and then when the mouse it over or it is click a window will op up showing the picture. Is this possible?"
          It's possible. You can even place a small "thumbnail" sized copy of the container field on you layout and set it up as a button that switches to a different layout where you have a large format copy of the container field. You can just switch layouts or use the new window command to pop up your picture in a new, separate window.

          There are also ways to use a web viewer to display the contents of a file such as a picture or PDF and there's a third party add on you can look into called super container.

          • 2. Re: pdf's and images in a database
            fluffyone

            Thanks Phil

            I need to play with this now.

            regards Fluffy