MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

doing "lookups" to return the value of more than one column

  Asked By: Scot    Date: Mar 13    Category: MOSS    Views: 2605

I am trying to create several lists that all have several columns in
common. Is there anyway to do a lookup to one column and pull back
multiple columns. For instance: I have a "clients" list with Client
name, client number, address etc now I am trying to create
a "Contacts" list that retains all of this information but then also
allows you to edit it (if need be) and also enter additional columns
and information. I would consider this a parent:child relationship. If
the clinet name changes on the parent it would also need to change on
the child. I am using SharePoint07. Any good pointers would be helpful.



3 Answers Found

Answer #1    Answered By: Octavio Dotson     Answered On: Mar 13

WSS lacks robust relational list  support. This is one of my top three
platform busters:

1. Large List Support
2. Relational List Support
3. OLEDB Reporting

Answer #2    Answered By: Judy Pittman     Answered On: Mar 13

Do you know if there is a way to do this using SharePoint Designer?

Answer #3    Answered By: Tricia Mullins     Answered On: Mar 13

I'm not aware of a way to do this with SPD. However, if you are a
programmer, you can create  a Custom Field Type that could pull  back
multiple columns  from the related list.