Thank you for your explanations, after 4 interventions I now know much more about the difference between primary, unique, index and I've learnt that foreign keys exits in my sql ;-)
And from this page: http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html I understand it is rather recommended NOT to use foreign keys, at least until mysql integrates it more fully. Cheers to people who replied, I am now a little bit more knowledgable about this topic and will be able ot helps others when the opportunity will arise. Have a nice day, Cordialement, Damien COLA http://www.VarMalin.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]