blanktarget Posted November 2, 2003 Share Posted November 2, 2003 I have 2 tables that relate.One table has a listing of \'groups\' and an auto_incrementing ID number The other has client name and address, etc. I want to be able to have a single client listing point to several \'groups\'. But the data will not be normailized if i have multiple \'group\' fields in each client row. What I\'m thinking is this \'name\', \'address\', \'website\', \'phone\', \'email\', \'group_id1\', \'goupr_id2\', ... Will this cause problems or am I doing that wrong? Quote Link to comment Share on other sites More sharing options...
blanktarget Posted November 2, 2003 Author Share Posted November 2, 2003 I forgot to say that I also have a \'client_id\' field within each client row Quote Link to comment Share on other sites More sharing options...
Alien Posted November 3, 2003 Share Posted November 3, 2003 create one more table that contains a mapping of client_ID to group_ID Quote Link to comment Share on other sites More sharing options...
blanktarget Posted November 3, 2003 Author Share Posted November 3, 2003 Oh okay, then they are linked. Thanks! 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.