4 Replies Latest reply on Feb 16, 2009 3:41 PM by CountryBoy1

    Current Record No.

    CountryBoy1

      Title

      Current Record No.

      Post

        How can I get the current record number of the cursor

      position (in Table View) to store it in a global field ? (The

      the record numbers go from 1.....n).
       The Get(RecordID) can be incorrect.  The Get(RecordNumber)
      seems to return the record number of the last record
      and ignores where the cursor is at.  This is for Filemaker
      Pro 9 Advanced.

        Thanks for your help.

       

       

       


        • 1. Re: Current Record No.
          TSGal

          CountryBoy1:

           

          The RecordID is the chronological record number.  The RecordNumber is the record number based upon the found set and/or sorted order.  If you are showing all records and unsorted, the RecordID and RecordNumber will be the same.

           

          For all of the records I displayed in Table view, the Get (RecordNumber) definitely returns the number of the record.  If I'm active in record "m" or "n" records, Get (RecordNumber) returns "m". 

           

          TSGal

          FileMaker, Inc. 

          • 2. Re: Current Record No.
            raybaudi
              

            TSGal wrote:

             

            If you are showing all records and unsorted, the RecordID and RecordNumber will be the same.

             


            Hi TSGal

             

            another condition must be true: you NEVER had deleted a record, otherwise the RecordId and the RecordNumber will be sometimes ( more than one time ) different.


            • 3. Re: Current Record No.
              raybaudi
                

              CountryBoy1 wrote:

                How can I get the current record number of the cursor

              position (in Table View) to store it in a global field ?


              Hi CountryBoy

               

              you can't store the current record number into a global field but you can if the field is a calculation field with calc: Get ( RecordNumber ) UNSTORED.

               

              Place that field into the Header part of the table and make the header visible in table view by going, when in layout mode, into menu:

               

              Layouts >>  Layout Setup... >> Views >> Properties... >> include header part


              • 4. Re: Current Record No.
                CountryBoy1
                  

                Dear Danielle:

                        I have marked your answer as a "solution".  Thank you very

                 much for your help.  The trick was to place the field into the

                 header and not have it as part of the table. Thanks again.

                     CountryBoy1