has_many :through

Hi     Thanks for your reply.Here in junction table user_groups I have the additionl storing like    id integer not null default nextval('user_groups_id_seq'::regclass)    contact_id | integer |    group_id | integer |    group_user_type_id | integer |

Sijo

Sijo Kg wrote:

Hi     Thanks for your reply.Here in junction table user_groups I have the additionl storing like    id integer not null default nextval('user_groups_id_seq'::regclass)    contact_id | integer |    group_id | integer |    group_user_type_id | integer |

Sijo

Ahhh - I see. You are not only recording the contacts belonging to a group, but also different *kinds* of groups.

May I suggest you actually create another model to handle group_types, something like this:

class Contact   has_and_belongs_to_many :groups   has_many :grouptypes, :through => :groups end

class Group   has_and_belongs_to_many :contacts   belongs_to :grouptype end

class GroupType   # Has a text field called "name"   has_many :groups   has_many :contacts, :through => :groups end

Grouptype.find_by_name("Manager").contacts

etc.

Am I on the right track here?