ssam97

Is there a way to connect various cells of one table to different tables as a link to show interconnected data? Possibly a Many to many relationship? For example if there was a table recording Investors information and one for Funds with a column for investors - would it be possible to click on the investor name in the Funds table and then be shown the details of the investor from the Investor information table?