2 Replies Latest reply on May 18, 2011 11:11 AM by SharonSickler

    Serial generated incrementally based on last record

    SharonSickler

      Title

      Serial generated incrementally based on last record

      Post

      When creating a new record, I want the serial field to get the last record's serial and add one.

      I think this uses a self join, which is what I've done, but my calculation, Max(JoinTable::Invoice ID)+1, always returns 1.

      The tables are joined on Invoice ID, and the Invoice ID field is an Indexed, Auto-enter Calculation, requiring unique, non-empty, numeric entries.