This is basically just another form of many to many relationship where you create a record in the join table that documents both which two individuals are linked, but also the nature of that relationship. An added detail here is that it's a many to many "self join" relationship.
Where RelatedDonors is another occurrence of the Donors table.
In your example where you document the fact that Donor A and Donor B were married by Donor C, you'd create two records in Donor_Relationships, one that links Donor A to Donor C and one that Links Donor B to Donor C. A third record would link Donors A and B to each other as spouses.
A field in Donor_Relationship would then document the nature of the relationship, Priest, wife, husband, etc...
What do you mean by creating a record that links donors A to donor B, etc.? I don't really understand.
How do I create a record that shows a link between two donors? Is this a visual link? I am having trouble visualizing what you mean.
Donor A (_pkDonorID = 543 ) is the wife of Donor B ( _pkDOnorID = 678 )
To show that Donor A is the wife of Donor B Create this record in Donor_Relationships:
To show that Donor B is the husband of Donor A:
Many to many relationships typically are implemented with portals to either the join table (Donor_Relationships--which enables creating or removing links by creating or removing join table reocrds ) or to the other related table (Which just lists all related records ) in order to list all linked records and details about each of those linked records such as the type of relationship.
You may find this demo file on many to many relationships helpful: https://www.dropbox.com/s/oyir7cs0yxmbn6i/ManyToManywDemoWExtras.fp7
Oh this makes sense. Between your explanation and this web page I found: http://help.filemaker.com/app/answers/detail/a_id/9922/kw/records%20from%20another%20table
... everything becomes clearer. Thank you.
How do I create the crow's feet for this one-to-many relationship? I created two tables and a join table. I made the three tables:
3. Related Donors
When I draw the links between the tables, Filemaker automatically generates solid lines with no crows feet to indicate a many to many relationship. Why is this happening?
Screen shot attached.
That should happen automatically. It is controlled by the field options you specify for the fields.
Donor ID should be an auto-entered serial number.
_fkDonorID and _fkRelatedDonorID should be number fields with no othe fields options specified. The single "connector" suggests that you have either defined them as auto-entered serial numbers or have specified the unique values validation. Both options are incorrect here and should be removed.
Donor ID_RelatedDon... is a field that should not exist. It should be the very same field from the very same data source table as Donors::Donor ID.
You create RelatedDonors by clicking Donors in Manage | Database | Relationships and then you click the duplicate button (two green plus signs) to make a copy of the Donors Tutorial: What are Table Occurrences? box. You can then double click this box to open a dialog where you can rename it.
Hello, I thought I created the relationships properly so that the join table would work properly when I created a portal table.
I went ahead to test it and this is what happened:
I went into my "Donor Relationships" layout and created a record that indicated that donor A was married to donor B.
I expected then that, when I go to donor A's profile, the portal table for "Donor Relationships" would show that donor A was related to donor B... and it did.
I also expected that, when I go to donor B's profile, the portal table for "Donor Relationships" would show that donor B was related to donor A... but it showed nothing.
I have attached a depiction of how I drew the relationships.
Donor full name and related donor full name should be removed from the join table. you don't need them. The relationships linking a given join table record to two donor records by Donor ID are sufficient to be able to access and display the Donor and related donor names from the donor table.
You are correct that if you relate donor A to donor B that you will not see that relationship when accessing the donor B record. Please refer to my previous post where I show creating one join table record to show that B is the wife of A and another join table record to show that A is the husband of B.
Is it possible to make it so that, I can click on the related donor's ID number and that will link me to opening that donor's record for viewing?
Go to related records can be used for that purpose.
You're my HERO PhilModJunk!!!! HERO HERO HERO.