I have two Custom Lists in SharePoint, Person and Company. A company can be linked to several people, and a person can be linked to several companies. Classic many-to-many relationship, here.
I can add a column to the Company table, with a datatype of "Lookup," enable multiple values, and "Get information from" the Person table. So, given any company I can adjust who is part of that company. And when looking at a particular Company, I can see the people, and click on their names to look at the Person. However I can't go backward, from the Person to the Company.
I could go in any add a similar column to the Person table, which links backward. But then we have to maintain the same data in two places. That is, when Fred get fired from FooCorp, I would need to remove the link from Fred to FooCorp as well as the link from FooCorp to Fred.
Is there a way to link backwards, somehow? I'm thinking of some type of calculated column, or some such.
If needed, I could go in with SharePoint designer and adjust the .asp code. I'm really hoping to avoid that as I don't know much about .asp or the other technologies which drive SharePoint, under the hood.
This is hosted WSS 2007.