Somewhat simple question on tables.

2001-12-31 Thread James L. Davis
Hello, I have a relatively simple question to ask. Any help is great appreciated. Let us say that I want to create a classic table that would have columns for a persons name, eye color, age, etc. However, I also want to store a list (somewhere) of that particular persons favorite foods

Re: Somewhat simple question on tables.

2001-12-31 Thread David J Jackson
James -- You haven't done enough book work this is basic db design stuff, covered in Dubois book and evey other, the short answer is: Primary Key - foriegn Keys i.e People table: person_id, # Primary key, unique and auto increment fname lname ... Food person_id # pulled from People table via