Double belongs to in AR?

Can you do a double belongs to in ActiveRecord? I wanted a column
made up of user ids matched with group ids (since I can't think of a
better way with my current knowledge of AR).

Something like the following:

class User<ActiveRecord::Base
   has_many user_groups
end

class Group<ActiveRecord::Base
end

class UserGroup<ActiveRecord::Base
   belongs_to :user
   belongs_to :group
end

#how would you make that work?

Thanks,
             Kyle

You are very very close:

class User<ActiveRecord::Base
has_many :user_groups

has_many :groups, :through=>:users
end

class Group<ActiveRecord::Base

has_many :user_groups

has_many :users, :through=> :user_groups
end

class UserGroup<ActiveRecord::Base
belongs_to :user
belongs_to :group
end

Might I suggest a name change? UserGroup might work better as Membership. It reads better, and it represents the actual entity you’re trying to handle. You can then use that model to manage the relationships directly. Find that record, delete it, and a user is no longer a member of a group.

group = Group.find(15)

group.memberships.create :user=>User.find(1) #add to a group

Membership.create(:user_id=>2, :group_id=>15) #another way to add to a group

Membership.find_by_user_id_and_group_id(1,15).destroy #delete a user from a group

Hope that helps!