AnsweredAssumed Answered

Conditional Numerical Sequence

Question asked by C.Kobel on May 17, 2012
Latest reply on May 22, 2012 by philmodjunk

Title

Conditional Numerical Sequence

Post

I'm creating a layout for driving routes. We have numerous routes (ie Lakewood, Long Beach, Cerritos, etc...) in our Routes field and need to assign each record a different sequenced number according to which route it's in. I'm hoping we can also set it to update any following numbers if we have to add a new record at a later date. I've been working with FM 11 for a few months, but this one is beyond me so far.

Example:

Name     Route     Route Order

Smith     Lakewood   1

Black      Lakewood   2

Osbourn  Cerritos      1

Frank     Cerritos      2

Blake     Lakewood   3

Thanks for any advice!

Outcomes