In MS Access you define relationships between Key ID fields by dragging a line on the screen from the parent table to the child table.
So, if you are enforcing "referential integrity" you can not delete data that is referred to by another table or mess up the basic db structure... (think I have this about right :) When you first create a db in MySQL... how do you tell MySQL which Key field in table A is related to a field in table B? Thanks for any help - tmb __________________________________________________ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php