On Thu, Jan 8, 2009 at 12:19 PM, Zoran BoĆĄnjak <Zoran.Bosnjak@sloveniacontrol.si> wrote:
I would like to have separate tables.
 
Example that I gave was simplified. In reality each block might have more parents and each block might also have more childs. So separate connection table will be easier to handle in application (when adding or deleting connections between blocks).
 
Zoran
 
Than maybe you can try exactly what in the example is:

child=MultipleJoin("Blocks", joinColumn="parent_id")

You can have as many children as you want (and no woman necessary ;-) )

But "one parent" only (no multiple parents - it does not work even in the real live)

If you are looking for many-to-many relationship, try this:
http://www.sqlobject.org/SQLObject.html#many-to-many-relationships

HTH

Petr

PS: please try to avoid "top posting" if possible