Rails - Oct 2006 - Using :through when has_many of itself?

I have a somewhat complex relationship that I can''t seem to express
properly. I have a model that has a has_many relationship to itself.

The idea is that a customer has a "state" and the states have a
prescribed flow to the next state. The idea is that a customer who is
in a state of "good standing" can''t go directly to
"blacklisted"
without first going through "probation" or "under review".

There are two models...

class State < ActiveRecord::Base
  has_many :from_state_flows, :class_name => ''StateFlow'',
:foreign_key
=> ''to_state_id''
  has_many :to_state_flows, :class_name => ''StateFlow'',
:foreign_key =>
''from_state_id''
end

class StateFlow < ActiveRecord::Base
  belongs_to :from_state, :class_name => ''State'',
:foreign_key =>
''from_state_id''
  belongs_to :to_state, :class_name => ''State'',
:foreign_key =>
''to_state_id''
end

I can''t get any ":through" relationship to work properly. The
best I
have is this:
  has_many :next_valid_states, :through => :to_state_flows, :source =>
:from_state_flows

I don''t really care if the solution is using a "through". I
just want
to get a list of the next valid set of states from the current state. I
can''t even figure out how to this through find() with an :include.

Any help is appreciated!
-Mark E.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---