2 Replies Latest reply on Nov 25, 2014 12:11 PM by philmodjunk

    Limits of Database size



      Limits of Database size


      Am I limited as to the size of a database? I have one Master File comprised of 3 tables with a total of aprox 30,000 records. I have many smaller files which I have made related to the maser file as I've learnt more about FM relational files. This is becoming a bit messy with much repeated info. Is there any reason not to bring the smaller files into the master file in the form of many new related tables. (This will necessitate as many as 500 layouts.)

        • 1. Re: Limits of Database size

          The only repeated information in a related table should be the key match field, there is no other reason for any other duplicated data.  There are two main reason to have a child table. 

          1 ) So you can have any number of related items such as notes.  If you had one field in the parent table then you would only have 1 note fields, but if you related in a child table then you could have 1 or more notes.

          2) If you have a very large database then it is easier to keep track if you had a different table for each pertinent task.

          • 2. Re: Limits of Database size

            It is possible to work with database tables in FileMaker that contain several million records. There can be extra precautions that need to be taken, but tables of such size are manageable.