Okay, head scratching time...
I have 3 modules which are related..a->b->c ( 1to many's )

Clearly we can show a subpanel of B's in A, and a subpanel of C's in module B, but what I would like to do is show a view(sub panel ) of 'Cs' in A. Dont need to be able to add items, just view.

Tried to 'fool' the system with a SQL view ( wasnt having it '-) ), and thinking we might have to create some sort of virtual/non-database module. Done the search/google, and little stuck...


Any ideas ?
Sugar 5.1, apache/mysql

Gary