3 Replies Latest reply on Apr 19, 2012 9:03 AM by CarlosSousa

    Id Key



      Id Key


       I created an Id key  number field  and choosed Auto Enter Serial 1 incremented by 1.

      My database has 3000 records. I thought the Id key would count my 3000 records but the field is empty in all records.

      I know the Id works when I enter a new record - but what can I do to count the actual 3000 records?

      I guess I'm not obliged to manually enter the Id number, 3000 times!

      Please help me.

      Thank you very much



        • 1. Re: Id Key

          Use replace field contents to assign a serial number to your existing records.

          1. Go to a layout based on your table.
          2. Select Show All Records
          3. Put the cursor in your serial number field. (You may need to add the field to your layout in order to do this.)
          4. Select Replace Field Contents from the Records menu
          5. Choose the serial number option and also select the option to update the serial number in entry options.
          • 2. Re: Id Key

            Auto Enter Serial puts the number in that field at the time of record creation. If your 3,000 records already existed then it was too late to use the auto-enter for these records. However, you can use, under the Records menu, Replace Field Contents to put a serialized number in this field after the fact, and will reset the next number in the auto-enter dialog if you so wish. Make backups of your file before attempting this procedure.

            I am not clear what you mean by count the actual records, if you want to know how many records are in the current found set, be they all or just a few, look at Get (FoundCount), this function is independent of any ID field. An ID key field's purpose is to provide a unique, never changing identifier of a record that is not tied to any other data in that record.

            • 3. Re: Id Key

               It worked! I followed  PhilModJunk advice and it worked just as I wanted it.

              Thank you very very much!

              I also thank to Bumper.