freeloader Posted June 26, 2009 Share Posted June 26, 2009 Hi guys, I have a table called DB_clients, it stores some general info about clients. Because I didn't want to make that table too big with 50 different columns, I've made another table with DB_clientCom, with information such as phone numbers, address etc. Is there some way I can link those 2 databases (or possibly more) so that there's at least one row in DB_clientCom for every entry in DB_clients? Link to comment https://forums.phpfreaks.com/topic/163775-auto-create-entry/ Share on other sites More sharing options...
Maq Posted June 26, 2009 Share Posted June 26, 2009 I have a table called DB_clients, it stores some general info about clients. Because I didn't want to make that table too big with 50 different columns, I've made another table with DB_clientCom, with information such as phone numbers, address etc. I would suggest you read and learn Database Normalization. Is there some way I can link those 2 databases (or possibly more) so that there's at least one row in DB_clientCom for every entry in DB_clients? You must utilize primary and foreign keys to link these tables. It's all covered in DB normalization. Link to comment https://forums.phpfreaks.com/topic/163775-auto-create-entry/#findComment-864167 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.