Nick Hird <[EMAIL PROTECTED]> wrote on 09/29/2005 05:03:53 PM: > Is there a way to have foreign keys and force referential integrity? I have > a main table and a lookup table, i want to be able to require that the main > table is using values from the lookup table. I am just not sure how in > MySQL. Thanks
Obviously you are new. Please do not take this the wrong way. We love to help people that are truly stuck, however you seem to be just a bit under informed about what MySQL can do. Please, allow me to help you to RTFM: http://dev.mysql.com/doc/mysql/en/index.html If you look in the index or use the search feature for Foreign Key, you will find what you need. IF you can't understand what you read. Please come back and post another question to the list and I or anyone else will be very glad to help. With respect, Shawn Green Database Administrator Unimin Corporation - Spruce Pine