Hi,
I have set up a simple test to experiment with relationship in Tap Forms (Mac OSX version).
I have three forms: father, mother and child.
The relation between father and child is one to many. The same applies for the relation between mother and child.
In the child form I have created inverse relationships to both the father and the mother forms.
I can create a child record and select its father from the already entered father records.
So far so good.
But when I try to select the corresponding mother record for this child record, the link and/or the information to the father record disappears. And when I reselect the father record, the mother information disappears again.
Am I doing something wrong or is this a bug?
Looking forward to your reply.
Regards, Mike.
Hi Mike,
The problem is that a child can have only one parent when you’re using a one-to-many link type. Your mother may have many children and your father may also have many children. But this does not mean that your child can belong to both mother and father at the same time. They can have only one parent. This is because the inverse of a one-to-many is actually a many-to-one relationship. That means many children can have only one parent and one parent can have many children.
If you’d like a child to have more than one parent, then you’ll need to use a many-to-many link. That way a mother and father can have many children and a child can have many mothers and many fathers :-)
Thanks,
Brendan
Hi Brendan,
Thanks very much for your help. That really did the trick.
Cheers and keep up the good work,
Mike.
.
