3 Replies Latest reply on Jul 19, 2010 9:50 AM by philmodjunk

    Scratch table?

    jjfcpa_1

      Title

      Scratch table?

      Post

      Is there a way to create a scratch (or temporary) table?

      I need a table that will contain a varying number of records based on criteria entered in a layout that will be used to generate a report.  Once the report is printed, the records need to be removed from the table.

      I guess I'm concerned about database bloating from populating and deleting records in a table time after time after time.

        • 1. Re: Scratch table?
          sunmoonstar.13

          Wouldn't it be simpler to just script a Find to locate the required records and then generate the report from that found set?

           

          Nick

          • 2. Re: Scratch table?
            jjfcpa_1

            No, because the information for the table needs to be calculated just prior to printing the report.

            Think of an amortization schedule where the parameters of the loan may change frequently.  What you're trying to do is print an amortization schedule based on the loan parameters.  

            The amortization schedule might contain 360 payments (30 year loan) and include payment number, payment date, payment amount, interest, principal, check number, notes.

            • 3. Re: Scratch table?
              philmodjunk

              "No, because the information for the table needs to be calculated just prior to printing the report."

              That doesn't necessarily require a separate "report" table. There are other reasons when such a table is useful, however and filemaker does not allow you to create and destroy tables via a script. If you are concerned that repeated imports and deletes might affect the file, you can take the precaution of occasionally saving a compacted copy of the file.