> You won't have duplicates[1], it's a sequence. It's its purpose. > > Now I may have missed something, I didn't follow this thread. Yes, what you quoted was more the intro. The actual question was how to find out what ids were generated during a sequence of insertions. -- Scott Ribe scott_ribe(at)killerbytes(dot)com http://www.killerbytes.com/ (303) 722-0567 voice