"Dave J. Hala Jr." <dave@58ghz.net> said: > > I think I'm just going to add a 100,000 to each field in the source > table, then add 200,000 to the target table.... that should take care of > it... > 100,000 seems a little extreme. You can say "select max(id) from mytable" and add 10 or 100 to it. -dc