Subform reciprocity for two forms

[bleyden]

Hello! I am having two issues with one of my subforms, so any help is greatly appreciated for one or both issues!

I have a main "Individuals" form with specific contact details, and a subform with "individual relationships" where I can list other individuals and their relationship type (primary, secondary, other). What I would like is that when I enter a record for a "relationship" between individuals, it appears on both individuals and not just the one that I manually entered. For example, in the image of Brendan's individual record he is related to tracy (which was entered manually), and I would like to see the relationship to Brendan when I retrieve Tracy's main record.

The other issue that I am having is that when I created the combo box for relationship type, which has options for "primary" "secondary" and "Other", i set it so that the data is stored in the relationship type field, but when I select an option it disappears and isn't stored. Any thoughts?

I have attached a screenshot for demonstration. If any clarification is needed please let me know!

Best,
Brendan

[ranman256]

The sub table would be:

personID1, personID2, Relationship


youd need to make a union query to get both columns as a single ID column.
and join it to the tPerson table to get their names to show.