assigning incrementing numbers for a group

[markga]

Help! I need to figure out how I can have my database assign an incrementing number, automatically, starting with 1 for each unique record for the specific group only.

Example: I have an assembly process (process id). Each process has any given number of steps, I need to auto number each step for that process id starting at number 1. I need this to happen for each unique process id.

I appreciate any help in resolving this, thanks.

[LiveOak]

Build a self join relationship where process id = process id. Set the next record process step = Max(self join::step no.) + 1. -bd

[This message has been edited by LiveOak (edited September 20, 2000).]

[markga]

thanks so much,it much more simple than I imagined (obviously).

Thanks again