I have a database with two parent tables and several child tables. I need to display a single parent record from one table with all the related records from each child on a single page. I thought the way to do that was to create a model and a view/template for each table and combine them all in the template for the parent table, but I can't figure out how to do this.
I can get the templates for the child views to load on the parent template, but can't figure out how to populate them from the associated model. I tried using the method demonstrated in the lendr tutorial (http://lendr.websparkinc.com/#beginning/editphp) of using a helper to load the view with the model, which seems to be exactly what I need, but I can't figure out how to get joomla to find the view (I get Fatal error: Class 'MycomponentViewWhatevs' not found in C:...). I've searched for days trying to figure out what I'm missing.
Is there a way to do what I'm trying to do? Am I going in the wrong direction? Should I be getting all the data using the parent table's model and duplicating the code for the child tables related to both parents (only a couple are related to both)? This is my first time working with joomla and php, and I am completely lost.