Jason Pruim wrote:
So my question is... When is it best to use more tables? All the info
will be related to each other, so I think I would be looking at either a
many-to-many relationship, or a many-to-one relationship (still figuring
that out).
One thing that I've realised make sense is to have a 'sub-table' for things
like phone number, email, fax and the like. All too often we have two phone
numbers or different email addresses, so a four field table with
ID number, type of info, info, note
This way one can add as many info fields of any different type to a
client/contact record. The type of info field flags things like primary phone.
Address details often need the same treatment as well, but I use UK post code
as a key for the bulk of that information so it just goes into a another info
field.
--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
