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

Reply via email to