At 11:28 AM 9/20/2001, you wrote: >Is there anyway to immediately have access to the id number generated when >the record is inserted? SELECT LAST_INSERT_ID(); http://www.mysql.com/doc/G/e/Getting_unique_ID.html ---- Anthony Baratta President Keyboard Jockeys "Conformity is the refuge of the unimaginative."