Relatively new Access user and first-time poster. My question pertains to self-joins and many-to-many relationships. The ‘rough’ database I created thus far involves relationships among individuals, sort of a genealogy concept. I will eventually grow this to try and show many-to-many relationships between and among individuals, families, corporations, and government agencies. The attached database has four tables (tbl_Individuals, tbl_Relationships, tbl_RelationshipTypes, tbl_RelationshipRoles), a query (selQry_Relationships), a form (frm_Individuals), and a subform (subf_Relationships). From the research I’ve done on this topic, I think I have correctly set-up the tables and relationships, though I wonder if I don’t need both a RelationshipRoles table and RelationshipTypes table. Seems they could somehow be combined. I think I have the query set-up correctly, too, but I don’t know where it comes into play. The plan is to use the main form to show/add new individuals and the subform to show/add new relationships. So far, I am able to add new individuals and create new relationships. What I can’t figure out is how to show the opposite relationship (bi-directional) in the Relationships subform. For example, the first individual in my table and form is Bob Smith. He is the Father of Tom Smith and the Grandfather of Joe Smith. When I move to the next record in the form, Tom Smith, the relationships subform shows that he is the Father of Joe Smith. It does not show that he is the son of Bob Smith. And when I move to the third record on the form, Joe Smith, no relationships are shown for him in the subform. I would like it to show that he is the Grandson of Bob Smith and the son of Tom Smith. Thoughts? Any help is greatly appreciated. Thank you!