Creating and Using True Self-referential Joins

I'm working on an application where people can sign up to use a
service and can refer others into the network. I'm wanting to use a
self-referential join table where I have one table with of course an
ID and an associate id where that will join to a parent record within
that table.

So if Jane referred in Tom then then Tom's associate id field would
have Jane's id # in it.

The I have several questions:

1) How do you set up a table that uses self-referential joins within
CakePHP and using cake migrations.

2) How would you reference those associations within the model?

3) How would you save to the database using a self-referential join.

Most of the posts on the user group have people using two different
tables and to me that's not a self-referential join. I'll do some more
searching. If CakePHP is a close port from Ruby on Rails then I guess
I could look at some Rails examples to see how they are doing. I think
they have acts_as_tree.

Thanks,
Tony
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---