John Trickett
Relation Manager for pivot table
Hi @Brian Kidd. Services can have multiple sites, so the site_id is defined in the pivot.
I'm beginning to think the solution maybe to treat this three way pivot as a model, then create a relation manager for that and specify the relationship between the pivot model and site, then use the relationship from the pivot model to services and contractors for the remaining data.
6 replies