Hi Shawn, First off thanks for the tip. I had read that page once already but after reading twice again after your post I realized that the answer was right there. Wrapping that concept around my brain really hurt but I get it now.
I had this: CREATE TABLE projects ( id int auto_increment, id_project int, id _client, PRIMARY KEY (id) ) When I should have this: CREATE TABLE projects ( id int auto_increment, id_client int, PRIMARY KEY (id_client, id) ) which now auto increments based on the id_client value such as: id id_client ------------ 1 1 2 1 3 1 1 2 4 1 2 2 1 3 This was the 'elegant' solution to my problem which was not really a problem after all. I have never gone beyond simple individual primary keys before so I never realized that this was so easy to accomplish. Hopefully this post will help some other future newbie out there. Thanks again, Dan T -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 1:29 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Custom Auto-Increment Problem Read this: http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html and post the SHOW CREATE TABLE for your projects table if that didn't answer your question. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]