Just created a table with a column named client_nr that is a foreign key referencing to my Clients table:
CREATE TABLE Contacts ( contact_nr int not null auto_increment, first_name char(30), last_name char(30), client_nr char (30), email char(30), tel_1 char(5), tel_2 char(30), mobile char(30), fax char(30), tel_home char(30), foreign key (client_nr) references Clients (client_nr), primary key (contact_nr) ) I know how to enter values using <insert into> but I don't know how to enter the right key value from the Clients table. thanks for any help! -- K MySQL --------------------------------------------------------------------- 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