2 Replies Latest reply on Nov 17, 2010 11:46 AM by JayWasack

    Merging Two files



      Merging Two files


      I have two files. Both share some common fields but one has fields I would like to get into the other.

      So, I guess my question is: how do I copy the data of one field into another file? Is is possible.

      Thank you in advance.

        • 1. Re: Merging Two files

          You need a field to copy the data into first.

          If you define new fields in the target table first, you can then use Import Records with the update matching option to update your existing records with the new data.

          You could also link these two tables in a relationship (You can link to tables in other FileMaker Files) and then use a script or Replace Field Contents to pull the data from a field in one table into a field in the other.

          • 2. Re: Merging Two files

            Thanks for the quick reply.

            I found that your suggestion indeed did work.

            I added the fields I needed into that database and then did an import with a matching option.