Passing Data Through Multiple Relationships

Question

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!

deldridgdeldrid · Answer

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.)

ivanweiss · Answer

Thanks, very much did it.&nbsp; One of those brain fart moments where I couldnt figure it out and it was so simple!

Forum Discussion

Passing Data Through Multiple Relationships

Related Content

File Manager Plugin Passing Data to the Child Records

Using Grid Edit to Edit Multiple Records at Once

Cross App Relationships

Edit Multiple Records at Once with Grid Edit

How to Link Tables in a Complex Many-to-Many Relationship?