Display Records from another table

Display Records from another table

I import data into 4 tables.  The 4 tables have a common field named "BEN".  When I am viewing a certain record in the "LEADS" table (which could be considered as the parent), I want to see the records in table #2 that has the same BEN; in the next section I want to see the records in table #3 that has the same BEN; in the next section I want to see the records in table #4 that has the same BEN.  How can this be accomplished?