I took your advice by inserting an entry without the id field, it was then auto assigned, and then I used the LAST_INSERT_ID() to update the record.

Have a good day and thanks for saving me a head ache!!!

-patrick