Purpose of my app is to request Quotes from our suppliers.
Lets say I send them a request for quote for 5 components that are used on project ABC123. And an additional 3 request for quotes for components used on project BirthdayCake.
I want to be notified when all 5 components have been quoted for ABC123 in one email.
And a separate email once all 3 components have been quoted for Birthdaycake.
I figured i would create a summary field, however that would require me to setup a relationship between two tables. My app only has one table.