Dear @admin,

I've read many old posts about this very question and just wondered, is this now possible to achieve in the builder itself by simply combining the 2?

Scenario
I have Organisations, Clients & Projects tables. The organisations are local authorities and schools and can and often do, have multiple addresses/sites and telephone numbers - therefore, the organisations table stores a main address. Organisations are 'parents' to clients where clients are in essence, a department of the organisation. Organisations become Clients when they are added to a project, at which point a separate address may need to be added.

Therefore, I'm now going to be adding a Contacts table in which to store related addresses with an FK to the client record. I know this may sound over-complicated but, I have 10k + records for organisations to populate and in the interest of keeping the DB normalised, I need to do it this way - so some clients will have 20 contacts (clients table) and others will just have one - their organisation address.

What I'm aiming for

1. An organisation fly view that displays all of the organisation details with a grid of secondary addresses from Contacts grouped by Clients (departments0
2. Similarly, a client fly view that displays all of it's contact details in a grid

If this isn't possible to achieve in the builder alone, am I right in thinking that I need to;

1. Copy all of the referenced vars from the view.html.php file of the grid into the view.html.php file for the fly
2. Add the output of the grid from the default.php in the fly view
?

Do I need to add an empty grid to my target fly views?

Also, is there anything I've missed?

Many thanks,

Gez

Sounds similar to the question I asked. admin did say he will document one day, and gave me a link which I think has part of the answer you need

www.j-cook.pro/forum/9-coding-inside-you...3922-need-a-reminder

Thanks @morganleecy k+1!

I've actually read that post (a long time ago) but it didn't come up in my searches earlier - must have been too narrow!

Will re-read it now that I understand cook a lot better than I did back then!

BTW, how did you get on with it? Was it successful?

Also, on an unrelated question (Just about to post about this too because I really can't find anything); As one of the seasoned devs here, just wondered if you've any experience of creating a custom toolbar button/task? Will link to my post now...

Many thanks,

Gez