Just an idear..Don't auto_increment the main table.. create a unique Id table, auto_increment that, and grab that value first for use with both fields in your main table.
Donovan -- D Brooke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org