We are testing SharePoint 2010 Standard and have a need to have relational data, but be able to view the data from both sides of the relation.
For example, I have a contacts list and I create a list for company and within the the contacts list use a lookup column using the company list. Is it then possible to click on the company name and be taken to a view/list that shows all contacts that are a part of that company?
I have created my list as described above but when I click the company link all that happens is I am taken to a window which allows me to edit the value of the company name and view specific record details (create time, who created, last modify).
If there are 3rd party add-ons required to achieve this, or tutorials on how I can create this (keeping in mind my skill level for SharePoint development is beginner). We just need to be able to demonstrate a proof of concept and dont need anything fancy, just need to have the budget and project approved then if needed we can spend the money on proper development.