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? Link to comment https://forums.phpfreaks.com/topic/1271-relating-problems/ 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 Link to comment https://forums.phpfreaks.com/topic/1271-relating-problems/#findComment-4243 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 Link to comment https://forums.phpfreaks.com/topic/1271-relating-problems/#findComment-4254 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! Link to comment https://forums.phpfreaks.com/topic/1271-relating-problems/#findComment-4264 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.