Associations without foreign keys???

Hi Folks,

I have a game where users get access to technologies. The technology records aren't owned - so a normal foreign key doesn't make sense.

I want to tell rails not to bother with xxx_id, and just to use conditions I set.

I can use finder_sql for a has_many     base.has_many :superstructures,                   :class_name => 'Technology',                   :finder_sql => "select * from technologies where category = 'Superstructure'" do                     def allowed                       find :all, :conditions => 'research_required < 2'                     end                   end

but the 'allowed' addition doesn't work

For a has_one, finder_sql doesn't seem to be an allowed option.

What I'd like is :foreign_key => nil, then I could put my logic in :conditions -but that doesn't seem to work either - rails just guesses the default key.

Is there a way to do this without just defining class methods on Technology?

Thanks.