September 19, 200025 yr 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.
September 21, 200025 yr 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).]
September 21, 200025 yr Author thanks so much,it much more simple than I imagined (obviously). Thanks again
Create an account or sign in to comment