Linking or daisy chain different tables onto one page

Hi all,

Still learning here and just wondered if you could point me in the right direction. This is a backend query in relation to Database in MySQL.

So, I have the following tables all in the same database.

• Table A
  Name
  ID

• Table B
  Field 1
  Role
  ID

• Table C
  Field 1
  Field 2 etc
  Role

So what I’m trying to achieve is when you search for Name in Table A (a contain) you can click on the ID. The ID will then show on the same page Table B, with the linked ID and also Table C with the linked Role.

I’m effectively wanting to show related info in 3 tables on the same page.

I’ve achieved the first step in Tabel A and the search. I’m just unsure how I now add the other two elements to the page?

Any tips or links, please
Thanks