Hey All, Sorry for the newbie question, at least I think it is. Here is my problem. I have 2 tables in my database with the following fields:
names_table and emails_table name_id (primary key auto increment) email_id (primary key auto increment) first_name name_id (foreign key) last_name email_address email_type (emum) Basically a one to many relationship. I have read a few books but am stumped on one thing, how can I get mysql to keep the name_id's in both tables the same integer. The name table increments fine but the email name_id does not increment. I am probably ignorant in saying this but I thought that since name_id in the emails table would be handled automatically by mysql since it is a foreign key. Is this a wrong assumption? Is it the job of the application to do this? Thank you in advanced for any help/suggestions. Devin B. Miller No electrons were hurt in the making of this email. --------------------------------------------------------------------- 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