1 Reply Latest reply on Jan 15, 2012 11:13 PM by Sorbsbuster

    Internal Record Order



      Internal Record Order


         When a record is deleted (that has a certain Index number)
      and then a new record is created later that uses the same
      Index number, Filemaker (for Show All Records) will always
      show the new record in the order that it was added, not in it's
      serial Index position.

          I have tried many scemes, including using Recover, but
      any new arrangement of the data (for Show All Records) will
      always show the previously deleted record in it's creation order
      and not in its serial Index position.

          This is mainly an aesthetic thing with me.  I can always
      have my "Show All" script include Sort by Index to get the
      Index order shown in serial order.

          Is there somehow an internal record order can be reset ?

          Thanks for your help.

        • 1. Re: Internal Record Order

          I wouldn't bother to 're-use' numbers.  It only leads to problems.

          If you really want it to look as if they were created in that order, I believe if you sort them the way you want and then import them into a clone they will appear in the order you want.   But I wouldn't bother.