>A view won't work as I have 3 related tables, with 2 of the related tables relating directly to the parent table.
I don't know exactly what this is not working but, also as Nadya recommended, a view is definitely the way to go here. Unless I'm missing something, it should be applicable even in this scenario.