sKreetz! (12/11/2014)
Thanks for the quick reply, Eirikur! It worked like a charm and I appreciate the help. As Sean mentioned, users may change their mind and remove line certain line items. Lets say there are 5 line items (1-5) and a user decided they don't need line item #3. It would throw off the numbers, showing 1, 2, 4, and 5. Is another function, or even a trigger needed to update the current line items to go in order? Possibly a FOR UPDATE trigger?
It has a problem but slightly different from what you describe, as the calculated column is not "PERSISTED" the numbering is always dense, removing items from a series will then truncate the series to the number of remaining items, hence alter the initial numbering.
😎