Jump to content


Photo

relating problems


  • Please log in to reply
3 replies to this topic

#1 blanktarget

blanktarget
  • Members
  • PipPip
  • Member
  • 12 posts

Posted 02 November 2003 - 11:24 PM

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?
It\'s not that I don\'t know how to do it, i just haven\'t learned it yet.

#2 blanktarget

blanktarget
  • Members
  • PipPip
  • Member
  • 12 posts

Posted 02 November 2003 - 11:26 PM

I forgot to say that I also have a \'client_id\' field within each client row
It\'s not that I don\'t know how to do it, i just haven\'t learned it yet.

#3 Alien

Alien
  • Members
  • Pip
  • Newbie
  • 9 posts

Posted 03 November 2003 - 07:48 AM

create one more table that contains a mapping of client_ID to group_ID

#4 blanktarget

blanktarget
  • Members
  • PipPip
  • Member
  • 12 posts

Posted 03 November 2003 - 04:01 PM

Oh okay, then they are linked. Thanks! :D
It\'s not that I don\'t know how to do it, i just haven\'t learned it yet.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users