iwiniquit Posted March 21, 2007 Share Posted March 21, 2007 hello everyone, basically i'm asking for opinions on how i should set up some tables. i'm working on a database for design projects i work on and within each project i'd like to list the client it was for. i made a new table just for my clients..but then i realized some projects have two related clients which i'd also like to list and categorize. like i did a job for the band The Fray, which was also for Columbia Records. so my main question is...should i have two seperate tables for the main client and sub client and have relation towards those? or just put them all in one 'clients' table? any thoughts would be greatly appreciated! -matt Quote Link to comment Share on other sites More sharing options...
DanDaBeginner Posted March 21, 2007 Share Posted March 21, 2007 for me seperate tables is the best... Quote Link to comment Share on other sites More sharing options...
fenway Posted March 21, 2007 Share Posted March 21, 2007 Usually separate is better, unless you have a ridiculous amount of data or it's being queried in strange ways. 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.