Page 1 of 1

Help With Relationships? Many to Many?

Posted: 2015-05-28 21:23
by 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?

Re: Help With Relationships? Many to Many?

Posted: 2015-05-28 21:45
by peebee