1 Reply Latest reply on Feb 26, 2013 8:23 AM by philmodjunk

    Frustrated with COPY FORMATS, TABLES



      Frustrated with COPY FORMATS, TABLES & LAYOUTS


           OK, this is really frustrating..............Why can't we simply COPY A TABLE FORMAT FROM ONE FILE TO ANOTHER?  The Helper File says that you can do it with the Manage Database Table commands but it does not work.  It copies the entire Table and all its records, and adds a new relationship, as well.  THIS IS RIDICULOUS!  I am certain that the older versions of Filemaker had this capability to easily copy a format in one file and paste it into another file because I remember doing it many years ago.  In my opinion, this is a BASIC FUNCTION that should never have been deleted.  Now, we have to create every tiny format from scratch, in all tables.  This is a total waste of time and money!  Whoever made this STUPID DECISION needs to be fired!  You also can't copy Layouts from other files either, like we could before.  So, instead of making my life easier, now this new version of Pro Advanced has taken me back about 15 years, to where I have to do everything ONE PIECE AT A TIME, IN EVERY FILE.  I might as well use pencil, paper and a copy machine again because that took much less time.  Please tell me that I am missing something................it should not be this difficult.

        • 1. Re: Frustrated with COPY FORMATS, TABLES & LAYOUTS

               It is not clear to me what you mean by "table format".

               You can certainly enter Manage | Database | Tables, select a table and then click "Copy". If can then click paste in this file or any other Filemaker file to paste a copy of the table into your database. This copies the design of the table, but not the data. However, this can only be done with FileMaker Advanced.

               In FileMaker Pro, you can also duplicate a table if you use Import Records with the "new table" option selected for the target table. This does also import data, but since Import Records imports data from the current found set, this need only be a single record that you import and then delete.

               On the other hand, you can go to Manage | Database | Relationships, select a "box" on the relationships graph and  click the duplicate button (two green plus signs) to get a duplicate Table Occurrence. This does not duplciate any table, but does produce a new way to reference the existing table for use in relationships.

               In none of these cases is a "new relationship created", so I am puzzled by what you mean by that.

               And none of this has changed in recent releases of the product.

               If what you really mean is that you want to copy a layout. Duplicate Layout will do that for the existing file and you can enter layout mode, select all layout objects and then copy them to the clip board. You can then navigate to a different file and layout in order to paste them. This can be made to work, but a great deal of attention to detail must be paid. You may even find it useful to paste the layout, import the scripts performed from buttons and script triggers on the layout, then paste the layout again. You also have to pay attention to the tables and table occurrences in the target file.

               This also is a process that has not changed for many different versions of FileMaker.