Passing Data Through Multiple Relationships

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered
  • (Edited)
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.

Thanks!


Photo of Ivan Weiss

Ivan Weiss

  • 1,304 Points 1k badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Photo of deldridg

deldridg

  • 262 Points 250 badge 2x thumb
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.)
Photo of Ivan Weiss

Ivan Weiss

  • 1,304 Points 1k badge 2x thumb
Thanks, very much did it.  One of those brain fart moments where I couldnt figure it out and it was so simple!