[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