1 Reply Latest reply on Jun 18, 2012 12:55 PM by philmodjunk

    Moving Records



      Moving Records


      I have a database that has a section to input upcoming work to be done. I was wondering if there was a way that once the work was complete it could be move into a new layout that is for completed work specifically. This would help with confusion and the database starts to have several years it won't be to overwhelming. 

        • 1. Re: Moving Records

          Layouts and tables are not the same thing. You can have many layouts that all refer the same table.

          The safest option is to leave all the records in one table. A FileMaker table can store millions of records so a few years worth of project records isn't likely to be too much for your database to handle. You can set up one layout with scripts that limit the records shown to only those where a status field equals a value that marks it as completed and a different layout can be used to display the records in the same table that are not complete.

          If you do choose to copy completed records into a second table, Import records can be used to copy one or a group of records from one table to another.