I'm building this site that is connected do databases. I obviously use HTML, PHP and SQL, and have three databases: Clients, Devices and Device Records.
When I open the site, I want a table to show all the clients and the number of devices they have (this is done). Then, when I click a given client, I want a table showing all the devices from that client, and then when I click a given device (they are all unique), I want to see their records.
So, my question is: what is the best way to do this? I know I can build a page for each thing, but this will be hard if I have hundreds of clients, each having hundreds of devices. Is there a better way?