This one is starting to fry my brain...
I have five tables:
I can't for the life of me create a query that returns the permissions for a given user.
I can get hasmanythrough to work with just one pivot table and a one-to-one relationship for the second step. But I can't get it to work when there are 2 many-to-many relationships.
Any help would be greatly appreciated :)