Passing Data Through Multiple Relationships
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 tr...
Forum Discussion
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.)
- Thanks, very much did it. One of those brain fart moments where I couldnt figure it out and it was so simple!
