First off: Did you have a typo when saying:
"s a pointer to the
COMMUNITY_TYPE_TABLE, which has a COMMUNITY_TYPE_ID as its primary key,
as well as a string COMMUNITY_TYPE_TABLE."
did you mean "as a string "COMMUNITY_TYPE_TITLE" ? cos i never saw that
title you refer to later anywhere in that explenation
Second: I'm pretty new to this stuff myself, so i just throw in my 2
cents, no promise it will work:
Tird: try this:
class CommunityType < ActiveRecord::Base
has_many :communities, :foreign_key => "community_type_id"
class Community < ActiveRecord::Base
belongs_to :community_type, :foreign_key => "community_type_id"
i'm not sure if you have to specify :foregn_key in the belongs_to, but
for sure in the has_many, cos otherwise Rails would assume that the
foreign_key in the COMMUNITY_TABLE would be the primary key
"community_id", but its "community_table_id"
... or i got you wrong or all twisted up Give it a shot.