I have been playing with ZoHo Creator for a little while now, I really like the minimalist IDE they've come up with, this sure does feel similar to writing code in Java, except for some syntax differences... I'm happy to learn something new!

Anyway, I am having a difficulty conceptualizing my report design in ZoHo Creator. Essentially my goal is this:

To display a Report (a List) based on the Child records in the database which incorporates data from key fields in the Parent table. As well, this Report should be able to display data from a 3^rd party table that only the Parent is related to (through “inheritance”). The data from all 3 tables should be accumulated in a single row so that each line of the List contains a mixture of these 3 sources of data.

Example: A production report which lists all Sterile Bandages (Children) manufactured company-wide and includes the Factory (Parent, 1:N relationship with Children) address as well as the Factory’s Air Filtration System type (only the Factory is related to the Air Filter Systems table [3^rd party table]). 

I very much appreciate you leading me in the right direction to make this happen, I hope to contribute back to the community in due time!