Originally Posted by
s@s
This makes sense but, displaying the total collections on the services level helps the user choose what line they need to select and drill down into the relevant collections. Having to click in each service in order to to see all related collections and then decide where they need to go is what im trying to help them avoid.
as a possible solution i thought i coul add the total_collections in the services table which i would need to calculate and store there each time a user exits the collections form.