"Nick the Gr33k" <nikos.gr...@gmail.com> wrote in message news:l50oo5$k05$1...@dont-email.me... > ???? 1/11/2013 7:07 ??, ?/? Paul Simon ??????: > >> If you have a list of values of the same type, but different values, >> you need a new table with a foreign key to the table it relates to. >> This is a relational database question. You can read more here: >> >> http://en.wikipedia.org/wiki/Database_normalization#Normal_forms > > I already answered to that in my previous post, this answer was Joel's > there was no need to retype it since i i saw it and responded to it.
Perhaps you misunderstood my response to Joel's comment. You don't <need> a many to many table as he said above in your quote. That's required for a normal form but isn't necessary. Denormalize the many to many form, have duplicated data in your only table if that works for you. Storage is cheap and its easier to create sql stsatements, too. Paul Simon -- https://mail.python.org/mailman/listinfo/python-list