Jump to content
  • 0

Many to many relationships.


ssam97
 Share

Question

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? 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0
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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...