I agree with leocharre that you're probably better off using a separate column for manually entered customer ID's. However, if there's more to it and you need to write your own routine to handle this problem, take a look at the DBIx::Sequence and DBIx::MySQLSequence modules.