Many to many relationships.

[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? 

[Mathilda]

On 10/28/2016 at 4:10 PM, ssam97 said:

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? 

Hi, I hope you still need help on this.

As far as I understand one Fund can have many investors and one investor can have many funds.

You need to create one more table to build a many to many relationship. Build a one to many relationship between Investor table and the 3rd table based on investor ID and one more one to many relationship between Funds table and 3rd table based on Fund ID.  So you will get a many to many relationship in the 3rd table. Then you may create a view using 3 tables and display needed information on report.

Please feel free to ask if you have questions.