4 Replies Latest reply on Oct 19, 2010 3:28 AM by LaRetta_1

    Automated Entry ID

    JoeJoseph

      Summary

      Automated Entry ID

      Product

      FileMaker Pro

      Version

      7

      Operating system version

      OS X10.9

      Description of the issue

      Some Entries are missing the Entry ID, I supposed the automation skips.

      For example, Entries assigned respectively: 1, 2, 4, 6, 7, 8, 11

        • 1. Re: Automated Entry ID
          philmodjunk

          Can you describe this in more detail?

          Precisely how is this Entry ID set up?

          Is this an auto-entered serial number field or something else?

          (It could be something as simple as records with IDs, 3, 5, 9 and 10 were created previously but have since been deleted or are not present in the current found set of records.)

          • 2. Re: Automated Entry ID
            josephjoseph

            I have field ----- "Headword"

            Then declared authomatic number generation for any "Headword" entry

            And that should be in field -----ID    And is +1

            e.g if i have "20 Headword Entries," then each entry should have a unique ID number as soon as they are created.

            so in total I should have 20 Headword and 20 ID number each belongs to every Headword.

            Problem:

            I view the tabular form, some entries are missing ID number

             

            • 3. Re: Automated Entry ID
              philmodjunk

              So the field is empty for some records?

              I'm not 100% sure I understand this part:

              Then declared authomatic number generation for any "Headword" entry

              And that should be in field -----ID    And is +1

              Is this an auto-entered serial number or a calculation? If it's a calculation, please paste the exact expression.

              If Headword is defined to auto-enter a serial number and with the "on creation" option specified, can you confirm that you selected these options for the field before you created any records in this table? (These options apply to each new record created, so records that already exist won't get a serial number entered just by selecting these options.)

              • 4. Re: Automated Entry ID
                LaRetta_1

                Possibly, have you ever imported and not checked 'perform auto-enter'?  This will also create new records without the serial.