Discussions

Expand all | Collapse all

Pulling connected records from separate tables

  • 1.  Pulling connected records from separate tables

    Posted 03-31-2017 13:41

    Hello!

    I created an app with two tables, Interviews and Insights. Each interview can generate many insights, and each insight can come from many interviews. I would like to see (both in the forms and in a report) all insights generated by an interview. Likewise, for each insight, I would like to see all interviews that generated that insight. I?ve been playing with many-to-many relationships and join tables with no success, as those require me to manually connect interviews and insights in the intermediate table so I view those connected records (or at least this is my understanding about how it should work). I would like to skip the manual connection step and leverage the link between insights and interviews created when I add an insight to an interview via the interview form. Is it possible? Thanks in advance!



  • 2.  RE: Pulling connected records from separate tables

    Posted 04-01-2017 04:15
    I'm leaning towards using a joined table, but there are some things you can do to make the "manual" part of it seem as if you are doing it all in one spot.

    While in the same breath giving you the reporting and insights (no pun intended) to your data.

    Have you experimented with an "editable" child table on the main interview form?  This would be your joined table, but you basically be a grid edit child list.  Makes it really easy to add multiple records at once.


  • 3.  RE: Pulling connected records from separate tables

    Posted 04-18-2017 22:10
    Thank you, Matthew! This works like magic! Problem solved!