Expand all | Collapse all

Passing Data Through Multiple Relationships

  • 1.  Passing Data Through Multiple Relationships

    Posted 07-15-2019 21:20
    I am trying to build a table for meeting minutes that has the functionality of summarizing a few related tables from my projects table.  I have attached a relationship diagram.

    Here is what I am trying to accomplish:

    • I have a projects table which is related to a meeting minutes table.  Each Project has many meeting minutes.
    • My meeting minutes table is related to the meeting minutes items table.  Each meeting minutes record can have many meeting minute items.
    • My project also has many discussion posts.
    • I am trying to show the records of discussion posts on my meeting minutes form as an embedded report.  But the "arrows" go in the other direction via the projects table so I cannot see the related table.  Not sure if I need to directly relate to the discussion posts table and filter the data?  I wouldnt think so but maybe I do?

    I want to do this over several tables so I was trying to figure out the cleanest way to do this.


  • 2.  RE: Passing Data Through Multiple Relationships

    Posted 07-15-2019 21:31
    You might try creating a report field in your Meeting Minutes table.  Report fields don't depend on table-to-table relationships and don't have to use the key field in either table.  You base the link on the Project ID field, i.e., records in the Discussion Posts table match records in the Meeting Minutes table if Project ID in each one matches the other.  (It will make more sense when you're actually setting up the field.)

  • 3.  RE: Passing Data Through Multiple Relationships

    Posted 07-15-2019 22:04
    Thanks, very much did it.  One of those brain fart moments where I couldnt figure it out and it was so simple!