This is still very much a work in progress, but I thought I would share what I have so far.
All sections will be hidden by default, all you will see is the installation number, and from there you will be able to drill down into each section.
I added some colors to to the tables to you can see what is linked to what.
For A/V Equipment I still wanna list all the inputs and outputs and then show where they go to.
What I have in mind for FK_xxx settings it that it will have a anchor that will link to the device when you click on it.
This is gonna take a while to get working like what I have in mind and I'm still trying to get myself familiar with the db and how things fit together.
Anyway, just a quick example at http://pastebin.com/SJjXmX0u
, just copy the code and save it into a html document.
Let me know what you think