Sounds like your structure is in your way.
You seem to have three entities (or maybe two...not sure)
Or are Org and Parent the same thing?
What you are looking to do would be very easy if your tables were set up as
Org---< Parent ---< Brand
Then you would simply put a portal on the parent table showing records from Brand.
If a Parent has more than one Brand...then Brand should be in a related table...not "flat" as you describe it.
It would seem you need at least two tables:
Parent: One record for every parent organization
Brand: One record for every brand, linked to Parent by ParentID--an auto-entered serial number field in Parent, but defined as a number field in Brand.
With this structure, you can place a portal to Brand on your parent table and see all the Brands for that Parent Organization. You can also set up a list view layout based on Brand with Fields from Parent placed in Sub Summary layout parts to produce a report that looks like this:
Parent Company Name 1
Parent Company Name 2
and so forth...
Yes, it was the structure...damn.. And the solution is really simple. I knew it was simple but wasn't hitting it in the right way....
I now have to reorganise it all (again for the 5th time in the last 2 years...oh well :) I'll apply the solutions then.
Thanks very much for your time!