I'm thinking that you should get all the common fields among the different types of people: F. Name, L. Name, Address, CC Number And then create a different table containing additional information that only pertains to certain types of people. Then join them using an id. - Jonathan "Alexander Deruwe" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hey all, > > I have 4 database tables, that each describe some sort of 'person' > (transporting company, truck-driver, ..) and have almost exactly the same > fields. > Is this the best way of storing this, or does this make more sense: > > One table, with all the same fields + 1 extra, noting the type of person > (that could come from yet another table). > > Any suggestions, 'cause this really bothers me. :) > > ad. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
