I am running W2k3 using SharePoint Services 3.0. I have a few lists which link to each other via lookup columns. I would like a view to display data which links across all lists. Can you provide a way to accomplish this?
Here is my sample which does not work the way I would like:
Column 1: "Company Name"
Column 2: "Phone #"
Column 1: "Full Name"
Column 2: "Cell #"
Column 3: "Company" which is of type "Lookup" which pulls from the above list
Column 1: "Full Name" which is of type "Lookup" which pulls from the above list
Column 2: "Meeting Title"
Column 3: "Meeting Details"
All of this works well.
Now, what I want is a view which shows info such as (which does not work):
Meeting Title Employee Name Employee Company Name
Budget review John Doh ACME
Sales meeting Jane Doh 7-11
I can display the Meeting Title, and Employee name, but the trouble I'm having is the view cannot pull the company details as it is kind of a 'nested record' from the Name List.
If you have any ideas or alternative ways to accomplish this, any help is appreciated.