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? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.