AnsweredAssumed Answered

Serial generated incrementally based on last record

Question asked by SharonSickler on May 18, 2011
Latest reply on May 18, 2011 by 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.

Outcomes