I'm currently working on a project that involves custom object relationships.I have two custom objects, let's call them "Project__c" and "Task__c". I want to create a relationship between these two objects, where a "Project" can have multiple "Tasks".
I initially thought about using a lookup relationship, but then I realized that I also need to roll up certain fields from related tasks onto the Project. From what I've gathered, roll-up summary fields only work on master-detail relationships, but I can't use master-detail because Tasks need to be unrelated to other Project records.

I'm currently working on a project that involves custom object relationships.I have two custom objects, let's call them "Project__c" and "Task__c". I want to create a relationship between these two objects, where a "Project" can have multiple "Tasks".
I initially thought about using a lookup relationship, but then I realized that I also need to roll up certain fields from related tasks onto the Project. From what I've gathered, roll-up summary fields only work on master-detail relationships, but I can't use master-detail because Tasks need to be unrelated to other Project records.