Help With Relationships? Many to Many?

[jay007]

I have 2 tables one called mother and another called child. A mother can have many children and a child can have one mother. In the Mother table I want to be able and see how many children the mother has and in the Child table I want to see the mother. I think I need many to many relationship. In appgini when I set the lookup fields I get

If you want to create a many-to-many relation, you should remove both lookup fields and create a third table that has lookup fields to both 'child' and 'mother'.

I don't really understand this could someone explain?

[peebee]

See this post for explanation: http://forums.appgini.com/phpbb/viewtopic.php?t=1188