Families, Sibling and Children

[grumbachr]

So I've been racking my brain on this one. The file is made to track families based around a Mother and Father (each with ids) and marriages. I can show all family using a family id, sibling based on marriage id, mother and fathers children based on their ids but in different portals.

I'm asking for help with trying show children for either the mother or the father in one portal.

I've been reading some about Multi-key (relatedtable::ID & ¶ & ID) relationships but i'm not sure if how i have the database setup breaks that or most likely its just outside my skills set for now.

It would be greatly appreciated if anyone would take a look at this file and make any suggestions on how to improve it.

families.fp7.zip

[mr_vodka]

Were you able to take a look into the recursive data structure model that I pointed out last time? I think it makes sense when trying to tie family or families in relationships.

http://fmforums.com/forum/showtopic.php?tid/194038

[grumbachr]

I really and I even built most of his solution as i read through the article.

There is a disconnect in my head in what exactly I need in this file and how the multi-key stuff was working in his example.

[grumbachr]

It can't really be this easy.

The one thing I am struggling with now is showing "All Family". Since this is supposed to be based on genetics certain groups should be showing up together but they aren't right now.

I'll keep working on it but thanks for the help.

RecursiveRedo.fp7.zip

[EdBaron]

I am fairly new at this. I did look at your Relationships. It seems to me that you have a number of "many to many" relationships and even relationships that are tied to two id's. It is my understanding that you should always have "one to many" relationships. You might have to make some intermediate tables to break the "many to many" relationships to "one to many"