3 Replies Latest reply on Nov 24, 2008 5:02 AM by jonnyt

    Combining Separate Database Files Into One File

    DrDave

      Title

      Combining Separate Database Files Into One File

      Post

      I was given five separate FM database files (One.fp7, Two.fp7, etc). These are all separate files, but they are all related to each other. 

       

      What's the best way to bring these files together into one physical file? Stated differently, into one fp7 file.

       

      All suggestions are appreciated. 

        • 1. Re: Combining Separate Database Files Into One File
          jonnyt
            

          We used to use older versions of filemaker, but once the multiple table feature was released we brought the extra filemaker files into one filemaker file by importing the data into a new table, then carefully chaning the relations.

           

           

           

          Go to file, manage database

          click the tables tab

          create a new table with the exact same structure as the file you want to import

          import the data from the file into the table

          create a layout to display the new table data

          text the data extensively to ensure everything is there

          re-create your external file relationships with new table relationships.

           

          voila!

           

           

           

          • 2. Re: Combining Separate Database Files Into One File
            MikeyG79
               Is there any automated way to do this? I have some extensive files I'd like to join but doing it by hand would take far too long.
            • 3. Re: Combining Separate Database Files Into One File
              jonnyt
                

              By going to file,

              import records,

              file

              choose the filemaker file to import

              select new table from the Taget: drop down box

              filemaker should create  the fields for you automatically

               

              you will then need to re-create any auto enter calculations, validation rules etc etc

               

              make sure you test, test and test for peace of mind!