[thelist] Database Normalization Question

rudy r937 at interlog.com
Tue May 14 15:22:01 CDT 2002


> Would I want to put fields in the table with the contact information
> to use to sort on or would I need to set up a second separate table
> which will hold the sort fields?

hi josh

i'm not sure i understand -- do you want to store something about each of
the web pages that the contact info is to appear on?  or are the web pages
which should include contact info separate, i.e. not related?

it sounds to me like contact-webpage is a one-to-many relationship, and
thus requires a separate table

as far as storing a sort field, this is done all the time

if you're still in doubt, give some more info, maybe an example

rudy




More information about the thelist mailing list