IvanWeiss
6 years agoQrew Captain
Meeting Minute attendees from a related set of data
I have some tables with some interconnected data. Let me first help to summarize my tables and my end goal:
Since I have the related project members I can easily pull from that table. However, I am trying to only allow the user to select from the related project.
For example if my contacts table has John, Joe, Sue, and Rachel.
John and Sue are part of Project A. Joe and Rachel are not. When I create meeting minutes for this project I only want to be able to select John and Sue as meeting attendees.
Thanks in advance!
- Projects has many meeting minutes
- Project has many project members
- Meeting Minutes has many meeting minute items
- Meeting Minutes has many project members
- Project Members has many contacts (so project members is a many to many join for projects and contacts)
Since I have the related project members I can easily pull from that table. However, I am trying to only allow the user to select from the related project.
For example if my contacts table has John, Joe, Sue, and Rachel.
John and Sue are part of Project A. Joe and Rachel are not. When I create meeting minutes for this project I only want to be able to select John and Sue as meeting attendees.
Thanks in advance!