Re: Help with Contacts



let me start from your last sentance - there is no "table for contacts"
- sharepoint does not work like that. you should not be looking to
directly read from the SQL.

regardless, what you are trying to do can be easily achieved with web
part connections. you should go to the page where you want to display
the information (I suggest you create one - go to the "create" page and
select "web part page") and add the two web parts for the two lists
side by side.
Make sure both web parts are displaying the field that is used to
connect the lists. otherwise it wont work.
Now, use the drop down menu from one web part to connect it to the
other one based on the shared field. You should be able to figure it
out by yourself from here on.

Ishai Sagi
Sharepoint tips: www.spstips.blogspot.com



caballeror wrote:
Hi,

I've created two contact lists in my SPS, the 1st one is the "Experts" and
the other "Organizations". The experts contains persons and their contact
information while the organizations contains org contact info. I did this so
I can create a column in the experts contacts that fetches the organization's
name from the organizations. It's like two tables, the "experts" is linked to
the "organization" via org name field, I have successfully done this, but now
I want to create a view/output that will let me show the data from both
tables/contacts based on the relationship. I hope I did not confuse you. If
there is no way to do this in SPS I can do it in SQL I just need to know the
table name for the Contacts.

.



Relevant Pages

  • Re: Subject: ASP.NET developer trying to understand Sharepoint Services 3.0
    ... If you are a ASP.net developer then you are a SharePoint developer :-) ... SharePoint is built with ASP.net. ... the SPS framework if at all possible. ... call up data in other lists, but it only will show one field at a time ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: This Discussion webpart
    ... and it's not a webpart. ... Microsoft to build this in SharePoint but they were not interested. ... > the out of the box discussion webpart in SPS 2003. ... > dramatically increase the success of discussion lists in my SPS roll-out. ...
    (microsoft.public.sharepoint.portalserver)
  • RE: Excel SharePoint 2003 Integration
    ... I was using SharePoint 2 and now I upgraded to SharePoint 3. ... Synchronize an Excel list with the SharePoint site ... Unlink the lists ...
    (microsoft.public.excel.misc)
  • Re: Microsofty Sharepoint dll viewed in Object browser
    ... The web services are available from the server. ... SharePoint Services, such as for creating or deleting sites. ... Lists Provides methods for working with lists and list data. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Persist user information using only out-of-the-box web parts
    ... Custom lists and the Data View Web Part will do everything you need -- In fact, your example is one that's taught in the SharePoint Bootcamp (link in my ... I wanted to have each user only change the XML portion of the web part, ... Can't create a custom web part (real easy to retrieve the user information in the tool pane). ...
    (microsoft.public.sharepoint.windowsservices)