Relational database

Relational database

I have three tables that share a unique id in common.  I need to create a form that can query each of those three tables and bring back the matching results into a table.  I would like the records referenced in the table to be links that will open up a report, printable as a pdf, that can pull info from each of the three tables.  How do I do this?