Solved: How to make a two way connection between rows in t... - Page 2

johndoe101 · 10-18-2022 12:49 PM

Ok here is the problem. I want to show that persons in a table are associated with each other. I would like to link PERSON A to PERSON B from INDIVIDUALS TABLE with the details of the association going to ASSOCIATES TABLE.

That way, regardless of which PERSON I view in Appsheet, I can see the association between both PERSONS.

Thank you!

dbaum

@johndoe101 wrote:

Are suggesting that I make the Association Source, and Associate columns Unique IDs?

No, I'm not suggesting you generate new ID values in those columns.

I am trying to distill a few key concepts for you to build on. That said, the thorough explanations are in @MultiTech's videos that @SkrOYC pointed you to.

Regardless, it sounds like for each row in the Individuals table, between the Association: and Associate: columns, you already have a comprehensive list of keys of relevant rows from the Associations table. Maybe all you need to do now is dereference each of those key lists to the IDs of the associated individuals and then combine those dereferenced lists. For example, consider creating another virtual column with an App formula along the lines of the following:

[Association:][Associate:] + [Associate:][Association Source:]

View solution in original post

How to make a two way connection between rows in the same table that link through a second table