Hi Ethan, in this case, you should manage the "keys" by your application, and store the used ids in aonther table, similar to a "sequence" in Oracle or Postgresql. Thats so if you want all the records un one table (a field for the letter, and the other for the numeric part).
Otherwise, having a table for each site will be enough, as Jimmy suggests. -- Andrés G. Montañez Zend Certified Engineer Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
