1 Reply Latest reply on Jan 15, 2015 8:47 AM by philmodjunk

    Please validate my understanding



      Please validate my understanding


      Intermediate Beginner here: I’m assuming that Script Step: ‘Show All Records’ destroys a current Found Set.  But is it safe to say that that is ONLY in the most recently referenced Layout?  i.e. are the Found Sets I established in other than the most recently referenced Layouts safe from ‘conversion’ back to All Records?

      Second (but I think similar) question: Does the pointer in ‘Go To Record/Request/Page [Next]’ stay associated with the last Layout referenced and not get ‘disturbed’ for other layouts.  I other words, can I skip from layout to layout and know that my Next Record pointer for each layout is accurate?

      TIA for sorting through this query with me…

        • 1. Re: Please validate my understanding

          Not quite, but close to correct.

          Found sets (including the current record and current sort order) are specific to a given Table Occurrence in a given FileMaker window. Table Occurrences are the "boxes" found in Manage | Database | Relationships. Each refers to a table, but you can set up more than one such occurrence for the same table. Every layout specifies a single table occurrence in the "Show Records From" drop down found in Layout Setup and also in the New Layout Wizard.

          So, for a given window, all layouts that specify the same table occurrence share the same found set, current record and sort order. A change to any of these will affect what records are displayed in all of the layouts that refer to the same table occurrence.

          Script steps that modify the found set, current record or the sort order all execute in the context of the current layout. They will modify (or attempt to modify) the found set of whatever table occurrence is specified for that layout. This also will be specific to whatever FileMaker window is current.

          And note that I keep referring to windows here. If you open a second window in FileMaker, you get a whole new and separate set of found sets for all of your table occurrences in this window. Changes to a found set will not affect the found set for any layout shown in a different window.