I have 2 tables:
people (id, name) children (id, parents_id, child_id)
parents_id = people.id and child_id = people_id also
So how I make a relationships in Rails?
And how can all search:
Children.find(:all, :conditions => ["parents.name LIKE 'Clin%' ??? Or how???
And what if I want to add new child. Parents name is in people table, but childs not, so how I do?
Sounds like a many to many relationship, in which case you need to declare has_and_belongs_to_many on both people and children. The relationship then works through a join table. If you did this, you'd need to re think your model a little and your find and add problems would be different. Martin
I think that the best solution to your problem is to use acts_as_tree
http://github.com/rails/acts_as_tree/tree/master
Martin Hawkins escribió: