6 Replies Latest reply on Sep 3, 2009 9:02 PM by mrvodka

    can you merge tables?



      can you merge tables?


      I've created 2 tables with many fields, and I now realize they belong in the same table.  Is it possible to merge the two into one?

        • 1. Re: can you merge tables?
             You can copy and paste the fields. Then you can import into the other table matching on your ID.
          • 2. Re: can you merge tables?

            It sounds like you're saying no, correct?


            You're saying copy and paste the fields in the Layout? and just have the 2 tables remain separate with a relational ID?


            (I'm using Filemaker Pro, not FMP Advanced) 

            • 3. Re: can you merge tables?

              Sorry. You can create the fields in the table. Then go to the layout of a TO where you want to import into. Then choose File --> Import. Select the same file that you have open. Choose the other table as the source and use the import option of 'Update matching records'. It will make you designate what fields you want to base the match on.


              So yes you can.

              • 4. Re: can you merge tables?
                   aaah.... But I still have to re-create the fields in the new table one by one, correct?  I can't somehow import them, or copy paste them?  I've created a whole bunch of fields in the other table, with pretty specific calculations, and don't want to have to re-do that work if possible.
                • 5. Re: can you merge tables?

                  If you have FMP advanced, you can copy fields ( or groups of fields ) and paste them into another table.


                  Without advanced, you can at least copy the calculation expressions one at a time.

                  • 6. Re: can you merge tables?
                       Simply copying and pasting the fields can be done quite simply with Advanced. I would suggest you get one copy if you plan on continued development. However, if not then perhaps you can find someone who has advanced and ask them if they can copy the fields to ther table for you. ;)